Oracle Data Guard Startup & Shutdown Steps

 

Follow the correct steps to start up and shut down Oracle Data Guard environments.

In this article we will look at Oracle Data Guard startup and shutdown sequence. You must follow proper shutdown order to perform a graceful shutdown.

Data Guard Shutdown Sequence

on standby

========

Stop log apply service or MRP and shutdown the standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> SHUT IMMEDIATE;

on primary

========

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

on primary

========

Startup primary database and enable log shipping

SQL> STARTUP;

SQL> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE';

on standby

========

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;