Startup/Shutdown Logical Standby Database


Simple Steps to do that


Shutdown Steps :

On Primary do the following :

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


Go to Standby :

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

Primary Database :

    SQL> shutdown immediate;


Startup Steps :

Primary Database


    SQL>startup;

 Standby Database:

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


Thanks.