ORA-16826: apply service state is inconsistent with the DelayMins property
Last updated on APRIL 04, 2018
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Goal
Data Guard Broker Configuration
DGMGRL> show configuration verbose;
Configuration - orcl1_site
Protection Mode: MaxPerformance
Databases:
orcl1 - Primary database
dgorcl1 - Physical standby database
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property <<<<<<<<<<<<<<<
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
Configuration - orcl1_site
Protection Mode: MaxPerformance
Databases:
orcl1 - Primary database
dgorcl1 - Physical standby database
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property <<<<<<<<<<<<<<<
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> SHOW DATABASE dgorcl1
Database - dgorcl1
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 2 minutes 33 seconds
Real Time Query: OFF
Instance(s):
dgorcl11 (apply instance)
dgorcl12
Database Warning(s):
ORA-16826: apply service state is inconsistent with the DelayMins property<<<<<<<<<
Database Status:
WARNING<<<<<<<<<<<<
Database - dgorcl1
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 2 minutes 33 seconds
Real Time Query: OFF
Instance(s):
dgorcl11 (apply instance)
dgorcl12
Database Warning(s):
ORA-16826: apply service state is inconsistent with the DelayMins property<<<<<<<<<
Database Status:
WARNING<<<<<<<<<<<<
Solution
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms