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

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

 Cause:

This warning was caused by one of the following reasons:
Re enable the standby database to allow the broker to restart the apply service with the apply options that are consistent with the specified value of the DelayMins property.

1. Apply service was started without specifying the real time apply option or without the NODELAY option while DelayMins is zero.

2. Apply service was started with the real-time apply option or with the NODELAY option while DelayMins is greater than zero.

Action:-

DGMGRL> show database orcl

Database - orcl

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: OFF

  Instance(s):    orcl

  Database Warning(s):

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

Database Status:

WARNING

DGMGRL> show database orcl

Database - orcl

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: OFF

  Instance(s):    orcl

Database Status:

SUCCESS

  

You have to run the following command on standby  to fix this warning.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

All the best...:)