Oracle Data Guard Startup & Shutdown Steps

 Data Guard Shutdown Sequence

Stop log apply service or MRP and shutdown the standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> SHUT IMMEDIATE;

Stop log shipping from primary and shutdown primary database

SQL> ALTER SYSTEM SET log_archive_dest_state_2='DEFER';
SQL> SHUT IMMEDIATE;

Data Guard Startup Sequence

Startup primary database and enable log shipping:
SQL> STARTUP;
SQL> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE';

Startup standby and enable log apply service or MRP:

SQL> startup nomount;
SQL> alter database mount standby database;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Thanks ,



1 comment:

  1. This was a useful and interesting read. I appreciate how clearly the information has been explained without making the article unnecessarily complicated for readers.
    Mumbai Morning Panel Chart
    Super Sridevi Night Chart
    Super Sridevi Night Panel Chart

    ReplyDelete

2015@Bahaa Barghouti. Powered by Blogger.