My Oracle Support Banner

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

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 = '<SERVICE_NAME> delay=0 optional db_unique_name=<DB_UNIQUE_NAME> 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=<SERVICE_NAME>) (INSTANCE_NAME=<INSTANCE_NAME>)(SERVER=dedicated)))", LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=30 db_unique_name="<DB_UNIQUE_NAME>" register net_timeout=180 valid_for=(online_logfile,primary_role)'

log_archive_dest_state_9 = 'enable'

log_archive_dest_state_7 = 'defer'

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.