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;

By mithun

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.