ORA-16416 Switchover Target Is Not Synchronized With Primary_753766.1

rongshiyuan發表於2014-04-30
synchronized

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


In this Document

Symptoms
Cause
Solution

Applies to:

Oracle Server - 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***

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

3rd standby site test_lag is included in the configuration, but it is not activated, eg:
log_archive_dest_state_4=defer
During switchover, primary will check all sites included in log_archive_config to ensure they are
in sync before switchover can proceed.

So ORA-16416 "Switchover target is not synchronized with the primary" is complaining for 3rd site test_lag.

Solution

Remove the 3rd site from the log_archive_config:
alter system set log_archive_config='dg_config=(test, test_stby)';
alter system set log_archive_dest_4='';

After this, switchover is fine.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1152008/，如需轉載，請註明出處，否則將追究法律責任。

相關文章