Log_archive_dest_state_2 Automatically Set To RESET Causing Standy Database To Fall Out Of Sync
Last updated on NOVEMBER 21, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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