• Arun Kumar

Data Guard Startup & Shutdown Steps

In this article we will understand about Oracle Data Guard clean startup and shutdown sequence.


Data Guard Shutdown Sequence


1. STOP LOG APPLY SERVICE

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2. SHUTDOWN THE STANDBY SERVER

SQL> SHUT IMMEDIATE;

3. STOP LOG SHIPPING FROM PRIMARY

SQL> ALTER SYSTEM SET log_archive_dest_state_2='DEFER';

4. SHUTDOWN THE PRIMARY

SQL> SHUT IMMEDIATE;

Data Guard Startup Sequence


1. STARTUP PRIMARY SYSTEM

SQL> STARTUP;

2. ENABLE LOG SHIPPING FROM PRIMARY

SQL> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE';

3. STARTUP STANDBY SYSTEM

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

4. START LOG APPLY SERVICE – MRP SERVICE

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


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

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback