Defer or Disable Log shipping on the Primary server:

If you want to Enable/Disable Archive Log shipping from Primary to Standby Server then execute below command on Primary Node


Defer or Disable Log shipping on the Primary server:

# connect / as sysdba

PRIMARY> ALTER SYSTEM SET log_archive_dest_state_2 = DEFER;


Enable Log shipping on the Primary server:

# connect / as sysdba

PRIMARY> ALTER SYSTEM SET log_archive_dest_state_2 = ENABLE;