Why DG cannot go sync after enable FSFO and start observer? (Doc ID 784469.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.3


Symptoms

After enable the Fast-Start Failover and Observer is started, the FS_FAILOVER_STATUS column of v$database still show "UNSYNCHRONIZED" for a long time.

The following Warnings from Data Guard Broker:

DGMGRL> show configuration

Warning: ORA-16608: one or more databases have warnings

DGMGRL> show database <Primary DB>;

Warning: ORA-16817: unsynchronized Fast-Start Failover configuration
Warning: ORA-16608: one or more databases have warnings.
Warning: ORA-16817: unsynchronized Fast-Start Failover configuration


Changes

From the paramter listing, it shows:

log_archive_dest_7 service = 'dg1wmprod delay=0 optional db_unique_name=dg1wmprod reopen=30'

log_archive_dest_9 service = '"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname1)(PORT=1521))(SEND_BUF_SIZE=375000)(RECV_BUF_SIZE=375000))(CONNECT_DATA=(SERVICE_NAME=dg1wmprod_XPT.homewarehouse) (INSTANCE_NAME=wmprod)(SERVER=dedicated)))", LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=30 db_unique_name="dg1wmprod" register net_timeout=180 valid_for=(online_logfile,primary_role)'

log_archive_dest_state_9 = 'enable'

log_archive_dest_state_7 = '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