Ora-16826:apply Service state is inconsistent

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 was 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 seconds
  Real time Query:off
  Instance (s):
    dgorcl11 (apply in Stance)
    dgorcl12

   database Warning (s):
    ora-16826:apply Service state was inconsistent with the Delaymins property <<<<& Lt;<<<<

Database Status:
warning<<<<<<<< <<<<

 

Solution

Workaround:

Check on which node MRP process is running.

On Standby

Make sure Standby redo logs files is created on Standby.

Please reference Interaction between the data guard Broker and a data guard Configuration Doc ID 249703.1

dgmgrl> Edit Database <standby database> set State=apply-off;
dgmgrl> Edit Database <standby database> set state=apply-on;

Or

Sql>alter database recover managed standby database cancel;
sql> ALTER DATABASE recover managed standby database using current logfile disconnect;

 

Verify Broker Configuration

Dgmgrl> Show Configuration

Configuration-orcl1_site

Protection mode:maxperformance
Databases:
Orcl1-primary Database
Dgorcl1-physical Standby Database

Fast-start failover:disabled

Configuration Status:
SUCCESS <<<<<<<<<<<<<<<<<<

Dgmgrl> Show Database DGORCL1

Database-dgorcl1

Role:physical STANDBY
Intended state:apply-on
Transport lag:0 seconds
Apply lag:0 seconds
Real Time Query:off
Instance (s):
DGORCL11 (apply instance)
Dgorcl12

Database Status:
SUCCESS <<<<<<<<<<<<<<<<<<<<<<

 

How to avoid this issue

1. This problem occurs if Managed Recovery are started manually which should not being done at all if there are an active Data Guard Broker Configuration.

Typically the Data Guard Broker should start Managed Recovery.

2. It can also happen if there is no Standby Redo Logs in place or they is incorrect configured-reference Usage, Benefits and limitations of Standby Redo Logs (SRL) Doc ID 219344.1

Ora-16826:apply Service state is inconsistent