Stop and Start Log Shipping for an Oracle Standby Database

Stop and Start Log Shipping for an Oracle Standby Database

DEACTIVATE THE LOG SHIPPING:

SQL> alter system set log_archive_dest_state_2=defer scope=both; (If RAC  sid = '*';)
System altered.

SQL> show parameter log_archive_dest_state_2
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
log_archive_dest_state_2             string      DEFER

SQL> select max(sequence#) from v$log_history;
         54276

SQL> alter system switch logfile;

SQL> select max(sequence#) from v$log_history;
         24277


ACTIVATE THE LOG SHIPPING:

SQL> alter system set log_archive_dest_state_2=enable scope=both; (If RAC  sid = '*';)

SQL> show parameter log_archive_dest_state_2
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
log_archive_dest_state_2             string      ENABLE

SQL> select max(sequence#) from v$log_history;
         54279

SQL> alter system switch logfile;

SQL> select max(sequence#) from v$log_history;
         54280