Procedure to apply the PROD incremental backup based on the SCN of the DR

Procedure to apply the PROD incremental backup based on the SCN of the DR

Note: Change the contents as per your Database requirement

1. Take the current SCN of the standby database-------------------------------STANDBY DATABASE

SQL>select to_char(current_scn) scn from v$database;

384749165

2. Stop the redo apply on the standby database------------------------------STANDBY DATABASE

SQL> alter database recover managed standby database cancel;

3. Take the incremental backup of the production database from the current SCN of the standby database(Value from sep1)---PRIMARY

run {

allocate channel c1 type disk format '/u02/Temp/AYYUDB_incr_%T_%U' maxpiecesize 500m;

allocate channel c2 type disk format '/u02/Temp/AYYUDB_incr_%T_%U' maxpiecesize 500m;

backup as compressed backupset incremental from scn 384749165 database;

}

4. Transfer the incremental backup to the standby system

 $ scp /u02/Temp /*.* usename@standbyhost:/u02/Temp/

5. Create new standby controlfile at the production database, copy this to standby system and replace current standby controlfile with this new one.---PRIMARY DATABASE

SQL> alter database create standby controlfile as '/u02/Temp/AYYUDB_standby_incr.ctl';

 

6.scp the standby control file

7.scp the password file from primary to standby Database in default location(overwrite on DR)

8. startup nomount using new standby control file--------------------------------STANDBY DATABASE

9.Mount the standby database--------------------------------STANDBY DATABASE

10. Catalog all the incremental backup pieces to the standby database--------------------------------STANDBY DATABASE

RMAN> catalog start with '/u02/Temp';

11. Apply incremental backup to the standby database--------------------------------STANDBY DATABASE

RMAN> recover database noredo;

12 Start redo apply on the physical standby database--------------------------------STANDBY DATABASE

 SQL> alter database recover managed standby database disconnect from session;

13.Compare Log Sync from Primary & Standby Datababse