<ul><li>To stop the Oracle Data Guard server, first, stop the listener service using 'lsnrctl stop <listener_name>'.</li><li>Next, cancel the managed recovery process by connecting to the database and executing 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;'</li><li>Finally, shut down the DR database using the command 'SQL> SHUT IMMEDIATE;'</li><li>To start the Oracle Data Guard server, start the listener service using 'lsnrctl start <listener_name>'.</li><li>Then, start the database in NOMOUNT mode using 'SQL> STARTUP NOMOUNT;'.</li><li>After that, mount the standby database using 'SQL> ALTER DATABASE MOUNT STANDBY DATABASE;'.</li><li>Lastly, initiate the managed recovery process by executing 'SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;'</li></ul>

How to Start and Stop Oracle Data Guard Server 19c

Discover more