Wednesday, August 29, 2012

DR REBUILD procedure

dr REBUILD PROCEDURE:
====================
1. Shutdown the standby database if it is running.
a) First cancel the recovery
sqlplus / as sysdba
sql> recover managed standby database cancel;
sql>shutdown immediate
b) stop the listener.
2. Put the all tablespaces in hot backup mode in prod.
3. Have SAN Administrator to Split the Disks and mount the disks on the standby server.
4. Put end hot backup on all tablespaces
5. create the standby control file
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/boston.ctl';
6. rsync the standby controlfile to the standby server
7. Bringup the standby db
a) copy the control file to normal control files loc.
b)create standby spfile from pfile
c)start standby listener
d)mount standby db and
start recovery =  alter database recover managed standby database disconnect from session;

8. Verify the standby recovery progress
a) Start remote archiving by forcing a log switch on the primary database node
$ sqlplus <user>/<pass>
SQL> alter system archive log current;
b) Tail the Standby Database alert log to verify there are no errors and make sure archive log switched
in previous step received by standby and Media Recovery delayed by 60 minutes for the log
9. Schedule archive job for standby db.

No comments: