HELP! Defer shipping to standby database - what do I need to do?
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