Database Backup and Recovery (MOSC)

MOSC Banner

HELP! Defer shipping to standby database - what do I need to do?

edited Jun 11, 2015 10:44AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

Hi,

We have a 11gR2 standby database located in a different site to our primary. Due to work on our networks there may be comms issues between both the sites.

To prevent any problems that might arise due to comms interruption is it enough to stop log shipping to standby for the duration of the comms work by executing the following on the primary db:

SQL> ALTER SYSTEM SWITCH LOGFILE;

SQL> alter system set log_archive_dest_state_2 = defer;


and doing the reverse once the work is complete as follows:


SQL >alter system set log_archive_dest_state_2 = enable;


At present we have scripts scheduled to do the following nightly on the standby database

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center