Planned outage at physical standby site
Posted on 2008-11-13
Here is possibly the easiest 500 points available today. We have a planned power outage for 4 hours this saturday at the site where our physical standby database is located. I plan on bringing the DR server down on Friday night and then back up on Saturday following the power outage.
I have made a list of commands - could someone verify that I haven't missed anything to ensure smooth running?
1) PRIMARY DATABASE
ALTER SYSTEM SET LOG_ARCHIVE_DEST_3=DEFER SCOPE=BOTH;
2) PHYSICAL STANDBY DATABASE
SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
(If the MRP0 or MRP process exists, then the standby database is applying redo. If log apply services are running, cancel them)
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
TO RESTART DR_COLT AND SHIP LOGS
3) PHYSICAL STANDBY DATABASE
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
4) PRIMARY DATABASE
ALTER SYSTEM SET LOG_ARCHIVE_DEST_3=ENABLE SCOPE=BOTH;