Check the scn on Standby database
select min(fhscn) from x$kcvfh;
Take incremental database backup on production
Take incremental backup on production and copy to Standby server.
rman target /
BACKUP INCREMENTAL FROM SCN 13176011749 DATABASE FORMAT ‘/backup/rmaninc/DBStandby_%U’ tag ‘DRSYNCdec28’;
BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT ‘/backup/rmanin/ForStandbyCTRL.bck’;
Copy all backup from production to DR
scp * root@10.100.x.x:/u04/rman1
DR Database
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
rman target /
startup nomount;
restore standby controlfile from ‘/u04/rman1/ForStandbyCTRL.bck’;
sql ‘alter database mount standby database’;
catalog start with ‘/u04/rman1’;
RECOVER DATABASE NOREDO;
alter database recover managed standby database disconnect from session;
Make sure listener is up and running on DR Database then
On production if required
alter system set log_archive_dest_state_2=DEFER scope=both;
alter system set log_archive_dest_state_2=ENABLE scope=both;