Archive

Archive for December, 2014

VMware Lab setup – A virtualized lab for testing HA and DRS

December 17, 2014 Leave a comment
Categories: Oracle

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

December 11, 2014 Leave a comment
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;

Categories: Oracle