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;
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.