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 ;
Post a Comment
Post a Comment