• Arun Kumar

Data Guard Startup & Shutdown Steps

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.

Make sure you have permission from application owner / database architect to perform primary shutdown.


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;

2,859 views

Recent Posts

See All

Oracle Data Guard Protection Modes

A Data Guard configuration always runs in one of three data protection modes (also called as redo transport rules): Maximum Protection Maximum Availability Maximum Performance (default mode of operati

Oracle Data Guard Physical Standby Configuration

There are various steps in which you can configure physical standby database. We need to make several changes to the primary database before we can even setup the standby database. This article applie

Client Connectivity in Data Guard Configuration

When you have a physical standby, you must make sure client connectivity is set properly so that when you perform failover or switchover, client must smoothly connect to the new primary. Create a data