ORA-16826: apply service state is inconsistent with the DelayMins property

When checking the configuration status in DGMGRL receiving the below error.

DGMGRL> show configuration

Configuration - DG_PROD

  Protection Mode: MaxPerformance
  Databases:
    Prod- Primary database
    Stdby - Physical standby database
      Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL> show database stdby

Database - Stdby 

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   (unknown)

  Apply Lag:       21 hours 51 minutes 5 seconds (computed 40 seconds ago)

  Apply Rate:      (unknown)

  Real Time Query: OFF

  Instance(s):

    ENTP1

  Database Warning(s):

    ORA-16826: apply service state is inconsistent with the DelayMins property

Database Status:

WARNING

As per the metalink document 1608166.1 we need to follow below to resolve the issue.

Solution:

*******

You need to restart the MRP with real-time apply mode.

DGMGRL> edit database stdby set state=apply-off;

DGMGRL> edit database stdby set state=apply-on;

or

SQL>alter database recover managed standby database cancel;

SQL> alter database recover managed standby database using current logfile disconnect FROM SESSION PARALLEL 10;

Here we need to start the MRP with parallel as there is a gap between standby and primary. And make sure Standby redo logs files are created on standby.

But we followed the below simple approach to resolve the issue. Just disable and again enable the configuration that will start the MRP with parallel.

DGMGRL> show configuration

Configuration - DG_PROD

  Protection Mode: MaxPerformance

  Databases:

    Prod- Primary database

    Stdby - Physical standby database

      Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Fast-Start Failover: DISABLED

Configuration Status:

WARNING

 

DGMGRL> disable configuration;

Disabled.

DGMGRL> show configuration;

Configuration - DG_PROD

  Protection Mode: MaxPerformance

  Databases:

    Prod - Primary database

    Stdby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED 

DGMGRL> enable configuration;

Enabled.

DGMGRL> show configuration;

Configuration - DG_PROD

  Protection Mode: MaxPerformance

  Databases:

    Prod - Primary database

    Stdby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

Warning: ORA-16610: command ‘Broker automatic health check’ in progress

DGMGRL> show configuration;

Configuration - DG_PROD

  Protection Mode: MaxPerformance

  Databases:

    Prod - Primary database

    Stdby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Alert log:

***********

Only allocated 111 recovery slaves (requested 128)

Parallel Media Recovery started with 111 slaves

Waiting for all non-current ORLs to be archived...

All non-current ORLs have been archived.

Mon Jun 13 21:11:07 2016

Media Recovery Log /oraEMC/prod/arch1/Prod_1_89006_51323279.ARC

Mon Jun 13 21:11:07 2016

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE 

Happy Learning :)