Defer Log Shipping Oracle Data Guard

Sometimes it becomes necessary to stop the log shipping procedure without doing a shutdown of the standby database or server. For eg: IF there is a network related activity in you organization and there will be a network outage. You can defer the log shipping. Or if you are relocating your standby database server. Please note : Log shipping has to be  enabled explicitly later for the logs to start applying on Standby server again.

On Primary database server

SQL> alter system set log_archive_destination_state_2=DEFER ;

this defers(delays the log shipping)

Now do a switch of logfile to confirm the logfile didnt come on the standby database. Alternately you can check from SQL command using.

On the primary server:

SQL> SELECT max(sequence#) AS “PRIMARY” FROM v$log_history;

On the standby server:

SQL> SELECT max(sequence#) AS “STANDBY”, applied

FROM v$archived_log GROUP BY applied;

Advertisements

4 thoughts on “Defer Log Shipping Oracle Data Guard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s