Steps to Shutdown and Startup Logical Standby Databases


Shutdown

On Primary Node

SQL > alter system switch logfile ;
SQL > alter system archive log current ; 

On Standby Node

SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;
SQL> shutdown immediate;

On Primary Node

SQL> shutdown immediate;



Startup

On Primary Node

SQL> startup;

On Standby Node

SQL > startup
SQL > alter database start logical standby apply immediate ;





If you like please follow and comment