High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center