Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

log_archive_dest_state_2=defer

user9527632Mar 19 2020 — edited Apr 6 2020

I don't  have an environment to do the test myself. I am wondering if I have a data guard setup,  suppose now sequence#=100 in my primary and I disabled logshipping to my standby location (log_archive_dest_2) by setting log_archive_dest_state_2=defer.  If I continue my primary for a day or two.  Now my sequence#=500 in my primary and I enabled log shipping.    Will Oracle start shipping logs to log_archive_dest_2 starting with sequence#101  or sequence#501?   Assuming all archived_logs are still on Primary.

Thanks!

Comments
Post Details
Added on Mar 19 2020
9 comments
3,011 views