Link to home
Start Free TrialLog in
Avatar of gflmartins
gflmartins

asked on

Planned outage at physical standby site

Hey,

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?

Thanks:

SHUTDOWN

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;
SHUTDOWN;


TO RESTART DR_COLT AND SHIP LOGS

3) PHYSICAL STANDBY DATABASE
STARTUP MOUNT;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

4) PRIMARY DATABASE
ALTER SYSTEM SET LOG_ARCHIVE_DEST_3=ENABLE SCOPE=BOTH;
ASKER CERTIFIED SOLUTION
Avatar of MikeOM_DBA
MikeOM_DBA
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial