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;
gflmartinsAsked:
Who is Participating?
 
MikeOM_DBAConnect With a Mentor Commented:

Maybe this:

-- Shutdown
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=DEFER SCOPE=BOTH;
-- and Startup
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=ENABLE SCOPE=BOTH;

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.