How to restart Oracle Standby Database (DG)

————————————————–
STARTUP PROCESS
————————————————–

Starting Primary Database: (PROD)

sqlplus “/as sysdba”

SQL> Startup

Startup Standby Database: (PRODDG)

SQL> sqlplus “/as sysdba”

SQL> startup nomount — Nomount state

SQL> alter database mount standby database;  — Mount in Standby mode

SQL> alter database recover managed standby database disconnect from session; — Start redo apply (recovery)

To verify the logs are applied on Standby, execute the below syntax on both primary and standby

SQL> select thread#, sequence#-1 from v$log where status = CURRENT;

SQL> select * from v$archive_dest_status where status != ‘INACTIVE’;

SQL> select sequence#, applied, to_char(first_time, mm/dd/yy hh24:mi:ss) first from v$archived_log order by first_time;



————————————————–
SHUTDOWN PROCESS
————————————————–

Shutting down Standby Database:

sqlplus “/as sysdba”

SQL> alter database recover managed standby database cancel;  — Cancel recovery fist.

SQL> shutdown immediate — Shutdown database

Shuttting down Primary Database:

SQL> sqlplus “/as sysdba”

SQL> shutdown immediate