Data Guard Shutdown/Startup Steps in Oracle

Data Guard Shutdown/Startup Steps

Shutdown

On Standby Node

Stop log apply service or MRP and shutdown the standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> SHUT IMMEDIATE;

On Primary Node

Stop log shipping from primary and shutdown primary database

SQL> ALTER SYSTEM SET log_archive_dest_state_2='DEFER';

SQL> SHUT IMMEDIATE;

Startup

 

On Primary Node

Startup primary database and enable log shipping

SQL> STARTUP;

SQL> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE';

On Standby Node

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;

If you like please follow and comment