Monday, May 7, 2012

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