ORA-16783: cannot resolve gap for database
I have two databases emadb and emadbdg, governed by Data Guard. emadb is currently primary. emadbdg is currently Physical Standby.
ORA16783 - Cannot resolve gap for database is one I think, is causing the problem. Can anyone help troubleshoot the issue below. Logs attached herewith.
Data Guard Output
DGMGRL> show configuration verbose
Configuration - DRSolution
Protection Mode: MaxAvailability
Databases:
emadb - Primary database
Error: ORA-16825: multiple errors or warnings, including fast-start failover-related errors or warnings, detected for the database
emadbdg - (*) Physical standby database
Warning: ORA-16817: unsynchronized fast-start failover configuration
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'FALSE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: emadbdg
Observer: emarn1
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
Auto-reinstate: TRUE
Configuration Status:
ERROR
DGMGRL> show database verbose emadb
Database - emadb
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
emadb
Database Error(s):
ORA-16783: cannot resolve gap for database emadbdg
Database Warning(s):
ORA-16817: unsynchronized fast-start failover configuration
Properties:
DGConnectIdentifier = 'emadb'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'emadbdg, emadb'
LogFileNameConvert = '/opt/app/oracle/oradata/emadbdg, /opt/app/oracle/oradata/emadb'
FastStartFailoverTarget = 'emadbdg'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'emadb'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emarn1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emadb_DGMGRL)(INSTANCE_NAME=emadb)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/opt/app/oracle/oradata/emadb/archivelog1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
ERROR
DGMGRL> show database verbose emadbdg
Database - emadbdg
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Real Time Query: OFF
Instance(s):
emadbdg
Database Warning(s):
ORA-16817: unsynchronized fast-start failover configuration
Properties:
DGConnectIdentifier = 'emadbdg'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'emadb, emadbdg'
LogFileNameConvert = '/opt/app/oracle/oradata/emadb, /opt/app/oracle/oradata/emadbdg'
FastStartFailoverTarget = 'emadb'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'emadbdg'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emarn2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emadbdg_DGMGRL)(INSTANCE_NAME=emadbdg)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/opt/app/oracle/oradata/emadbdg/archivelog1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> exit