Data Guard Startup & Shutdown Steps

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

Stop log apply service or MRP and shutdown the standby

on Standby

=========

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> SHUT IMMEDIATE;

Stop log shipping from primary and shutdown primary database

on primary

========

SQL> ALTER SYSTEM SET log_archive_dest_state_2='DEFER';

SQL> SHUT IMMEDIATE;

Data Guard Startup Sequence

Startup primary database and enable log shipping

on primary

========

SQL> STARTUP;

SQL> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE';

Startup standby and enable log apply service or MRP

on standby

=========

SQL> startup nomount;

SQL> alter database mount standby database;

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