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
No comments:
Post a Comment