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