My Oracle Support Banner

ORA-16826: apply service state is inconsistent with the DelayMins property (Doc ID 1608166.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information 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

 

  

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<<<<<<<<<<<<

  

 

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.