This content has been marked as final. Show 4 replies
Defer the remote archive destination on primary
SQL> alter system set log_archive_dest_state_2=defer;
Then perform several log switches on the primary.
Shutdown the listener on the standby
Change the password on the Primary
Change the tnsnames on the primary for the standby
Unplug the network cable on the standby
Edited by: mseberg on Jan 14, 2013 11:57 AM
Ok, when I break down the network connection, of course the new archivelogs are not on the standby site. however after establishing the connection they are on the standby site even when I deleted them on primary.
It looks like dataguard is too intelligent to be fooled.
I thought it were possible to disturb it somehow that archivelogs are copied to the standby site, so the query
select * from v$archive_gap
would output some rows even after reestablishing the connection.
Have never trusted v$archive_gap
Try this :
Another thought is to DEFER and then move the archive on the primary and see it that creates a gap.
thank you it helped me a lot