Last updated on OCTOBER 12, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 7th-Aug-2014***
The database initialization parameter log_archive_dest_state_2 is automatically set to RESET in the primary database after the standby switchover, causing standby to fall out of sync.
After setting it to ENABLE, the logs start applying in the standby database, however after few log switches the log_archive_dest_state_2 changes back to RESET.
A switchover was performed between the primary and the standby databases.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms