How to Start and Stop Oracle Data Guard 19c

Oracle Data Guard for data protection and high availability. Knowing how to start and stop the Oracle Data Guard server is essential for database administrators. This document will explain the process step-by-step.

Steps to Stop the DR Database

Stop the Listener

lsnrctl stop <listener_name>

    

Replace <listener_name> with the name of your database listener. This command stops the listener service that facilitates client connections to the database. 

Cancel Managed Recovery

Connect to the database using SQL*Plus and cancel the managed recovery process:

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

      

This halts the recovery process for the standby database.

Shutdown the Database

Execute the following command to shut down the DR database:

SQL> SHUT IMMEDIATE;
ORA-01109:database not open
Database dismounted.
ORACLE instance shut down.
SQL>

    

This indicates that the database has been successfully stopped.

---

Steps to Start the DR Database

Start the Listener

lsnrctl start <listener_name>
    

Replace <listener_name> with your database listener's name. This command starts the listener service.

Start the Database in NOMOUNT Mode

  
SQL>STARTUP NOMOUNT;
ORA-32004:obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLEinstance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 23334936 bytes
Variable Size 3489660928 bytes
Database Buffers 1.7918E+10 bytes
Redo Buffers 43769856 bytes

    

 

Mount the Standby Database

  
SQL>ALTER DATABASE MOUNT STANDBY DATABASE;
Database altered.
      

Mounting the database prepares it for recovery or other operations.

 

Start Managed Recovery

Begin the recovery process by disconnecting the session:

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

Database altered.
     

This command ensures that the standby database continues recovery in the background.