Home > Oracle > Oracle Standby gap .. simple steps to get it up and running again

Oracle Standby gap .. simple steps to get it up and running again

stop the redo on the standby database
sql> alter database recover managed standby database cancel;
determine the current SCN for the standby database
sql> select current_scn from v$database;
use the value for the current SCN to take your incremental backup on the primary
rman> run
{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup incremental from scn <scn number from above> database format '/tmp/bkups/PRODNPP_%U';
release channel d1;
release channel d2;
}
on the primary obtain a new standby control file and copy it to the physical standby
sql> alter database create standby controlfile as '/tmp/stdby.ctl'
copy the backup set and control from the primary to the standby
use either scp or sftp, etc
shutdown the standby and replace the controlfile and startup the standby in mount mode
sql> startup mount
catalog the backup using the target database controlfile
rman> catalog start with '/tmp/bkups';
recover the database from the increatment backup using noredo
rman> recover database noredo;
restart the MRP process
sql> alter database recover managed standby database using current logfile disconnect;

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: