————————————————–
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
