ORA-16416 Switchover Target Is Not Synchronized With The Primary (Doc ID 753766.1)

Last updated on AUGUST 05, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-NOV-2012***
***Checked for relevance on 06-Aug-2014***

Symptoms

Physical standby setup, standby has applied the lastest archive log from primary site, but switchover still report error:

Mon Nov 24 14:57:18 2008
ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY WITH SESSION SHUTDOWN
Mon Nov 24 14:57:18 2008
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY (testdr1)
Mon Nov 24 14:57:18 2008
Performing log switch to complete LGWR archival of current logfile
Archiving all current logfiles on all instances
...
Mon Nov 24 14:57:51 2008
ARCH: Noswitch archival of thread 1, sequence 45
ARCH: End-Of-Redo Branch archival of thread 1 sequence 45
ARCH: Evaluating archive log 3 thread 1 sequence 45
Archive destination LOG_ARCHIVE_DEST_4 invalidated
DB_UNIQUE_NAME attribute is required
..
Mon Nov 24 14:57:53 2008
ARCH: Completed archiving thread 1 sequence 45 (2256037103818-2256037103829) (testdr1)
ARCH: Archiving is disabled due to current logfile archival
Switchover target is not synchronized with the primary
ORA-16416 signalled during: ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY WITH SESSION SHUTDOWN...


Configuration is like:
log_archive_config = dg_config=(test, test_stby, test_lag)
log_archive_dest_1 = location=/u02/oracle/admin/testdr/arch/test1 arch mandatory noreopen max_failure=0 valid_for=(ONLINE_LOGFILE,ALL_ROLES) db_unique_name=test
log_archive_dest_2 = service=test_stby lgwr ASYNC noaffirm delay=0 max_failure=10 reopen=15 net_timeout=180 valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=test_stby
log_archive_dest_4 = service=test_lag arch delay=1440
log_archive_dest_state_1 = enable
log_archive_dest_state_2 = enable
log_archive_dest_state_4 = defer

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