DG broker error
Hello Gurus,
RHEL 7,Oracle 19.6
dg broker throwing below error even though the standby is in sync.
DGMGRL> show configuration;
Configuration - dgconfig
Protection Mode: MaxPerformance
Members:
ope551c - Primary database
Error: ORA-16724: cannot resolve gap for one or more members
ope551cs - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
ERROR (status updated 52 seconds ago)
SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,