Log_archive_dest_state_2 Automatically Set To RESET Causing Standy Database To Fall Out Of Sync

(Doc ID 1470986.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms