RMAN Incremental Backup Scenario in DR (Standby Database)
Checking Dataguard SYNC status
Standby Database (DR)
----------------
SQL>select distinct(checkpoint_time) from v$datafileheader;
CHECKPOINT_TIME
---------------
24-04-1998 18:10:20 ----------------->Should be current date and time to be in SYNC
DR database is out of Sync since Checkpoint time (as above output) leading to Archive Job failure on Production. We need to apply RMAN incremental backup as Archives are on TAPE and taking time to get restored.
Checking Dataguard SYNC status
Standby Database (DR)
----------------
SQL>select distinct(checkpoint_time) from v$datafileheader;
CHECKPOINT_TIME
---------------
24-04-1998 18:10:20 ----------------->Should be current date and time to be in SYNC
DR database is out of Sync since Checkpoint time (as above output) leading to Archive Job failure on Production. We need to apply RMAN incremental backup as Archives are on TAPE and taking time to get restored.
This is really a helpful blog I am really impressed with your work, keep it up the good work
ReplyDeleteOracle Database Certification