Steps to Shutdown and Startup Logical Standby Databases

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