A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time permitted that data can be restored from, which may or may not mean data loss. RPO concerns with data. It is the amount of data you are willing to lose when the failure occurs in your database system. Usually people … Read more
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh To save the script and change its permissions, follow these steps:1. Save the script by typing `:wq` in the editor.2. Change the file permissions using the `chmod` command. Add this entry to the crontab for the oracle user:
Add the Target Database TNS entry to the Source’s tnsnames.ora file(s) (all of them if it’s a clustered Source) Set the log_archive_dest_<#> parameter on the Source Database, as Oracle: Then enable the log_archive_dest_state_ parameter on the Source Database, as Oracle: Set fal/standby_file_management parameters on the Target Database, as Oracle: Using the db_unique_name, set log_archive_config parameter … Read more
On Source, as Oracle user: On Target, as Oracle user: Hope it helped !! 🙂
Overview: As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby. In 12c, this procedure has been dramatically simplified. You can use the RECOVER … FROM SERVICE command to synchronize the physical standby database with primary database. … Read more
1) Information of database (Primary & Standby). 2) To display current status for Physical Standby Database background processes. 3) Check for messages/errors 4) Show received archived logs on physical standby 5) To check the log status 6) To display various information about the redo data. 7) Verify the last sequence# received and the last sequence# … Read more
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown – rename to correct file ORA-0111: data file 185: ‘/u01/oracle/product/19/db/dbs/UNNAMED00185’ ORA-01157: cannot identify/lock data file 185 – see DBWR trace file ORA-01111: name for data file 185 is unknown – rename to correct file ORA-0111: data file 185: … Read more
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Solution: 1) At the primary site, take a backup of the datafile: 2) Transfer the file to the standby site using an operating system utility such as scp, NFS, ftp etc 3) At the standby site, catalog the backup piece and confirm it’s available … Read more
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prod/system01.dbf’ Suppose we are facing this issue while opening the database with resetlogs option. We have to check how many files have been recovered. We can check with the … Read more