I have been getting the below alerts from OEM.
The Data Guard status of ALP is
Error ORA-16724: cannot resolve gap for one or more
standby databases.
I checked the status of the standby and primary.
DGMGRL> show database verbose 'ALPLS'
Database - ALPLS
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 647.00 KByte/s
Real Time Query: OFF
Instance(s):
ALPLS1 (apply instance)
ALPLS2
Properties:
DGConnectIdentifier = 'alpls_lstby'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO' ===>> this looks good. It should be uppercase. Let's check primary
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/ALP, +DATA/ALPLS, +RECO/ALP, +RECO/ALPLS'
LogFileNameConvert = '+DATA/ALP, +DATA/ALPLS, +RECO/ALP, +RECO/ALPLS'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName(*)
StaticConnectIdentifier(*)
StandbyArchiveLocation(*)
AlternateLocation(*)
LogArchiveTrace(*)
LogArchiveFormat(*)
TopWaitEvents(*)
(*) - Please check specific instance for the property value
Database Status:
SUCCESS
|
DGMGRL> show database verbose 'ALP'
Database - ALP
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ALP1
ALP2
Database Error(s):
ORA-16783: cannot resolve gap for database ALPLS
Properties:
DGConnectIdentifier = 'alp_prod'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'auto' ============>> it should be capital AUTO.
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/ALPLS, +DATA/ALP, +RECO/ALPLS, +RECO/ALP'
LogFileNameConvert = '+DATA/ALPLS, +DATA/ALP, +RECO/ALPLS, +RECO/ALP'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName(*)
StaticConnectIdentifier(*)
StandbyArchiveLocation(*)
AlternateLocation(*)
LogArchiveTrace(*)
LogArchiveFormat(*)
TopWaitEvents(*)
(*) - Please check specific instance for the property value
Database Status:
ERROR
|
DGMGRL> help edit database ===>> run this to understand
options and commands.
SOLUTION:
DGMGRL> EDIT DATABASE 'ALP' SET PROPERTY StandbyFileManagement='AUTO';
Property "standbyfilemanagement" updated
After Fix check status:
DGMGRL> show database verbose 'ALP'
Database - ALP
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ALP1
ALP2
Properties:
DGConnectIdentifier = 'alp_prod'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
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 = '+DATA/ALPLS, +DATA/ALP, +RECO/ALPLS, +RECO/ALP'
LogFileNameConvert = '+DATA/ALPLS, +DATA/ALP, +RECO/ALPLS, +RECO/ALP'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName(*)
StaticConnectIdentifier(*)
StandbyArchiveLocation(*)
AlternateLocation(*)
LogArchiveTrace(*)
LogArchiveFormat(*)
TopWaitEvents(*)
(*) - Please check specific instance for the property value
Database Status:
SUCCESS
|
Lets check the status of configuration:
DGMGRL> show configuration
Configuration - alp_dg
Protection Mode: MaxPerformance
Databases:
ALP - Primary database
ALPLS - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
|
That is it you resolved the error.
No comments:
Post a Comment