Log_archive_dest_state_2 Automatically Set To RESET Causing Standy Database To Fall Out Of Sync (Doc ID 1470986.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 7th-Aug-2014***

Symptoms

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.

Changes

 A switchover was performed between the primary and the standby databases.

Cause

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