Disaster Recovery (DR) Startup and Shutdown Commands

Steps to shutdown a DR Database:
Note: Before shutting down a DR Database it is good to make sure that both Production and DR Databases are in sync.

SQL to check if both PROD and DR are in sync and the SQL needs to be executed on the PROD:

SQL> select max(sequence#), max(sequence#) "Applied log" from v$archived_log where applied='YES';

Example Output:
MAX(SEQUENCE#) APPLIED LOG
-------------- -----------
32412 32412

DR Shutdown commands:

SQL> alter database recover managed standby database cancel;

SQL> shutdown immediate;

DR Startup command:

SQL> startup nomount;

SQL> alter database mount standby database;

SQL> alter database recover managed standby database disconnect from session;