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:

- The apply service was started without specifying the real-time apply option or without the NODELAY option when the DelayMins property was set to zero.

- The apply service was started with the real-time apply option or with the NODELAY option when the DelayMins property was set to a value greater than zero.

Action: Reenable 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.

Solution  :

First look at dataguard broker file :
if the error is that :

DG 2008-10-27-12:29:46 0 2 0 RSM: Redo Apply is running without USING CURRENT LOGFILE option while DelayMins=0

 Then, On standby database disable redo apply  :

 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL ;

and enable with this:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

if problem is not solved, you may try these commands on standby database :

 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL ;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT NODELAY;

if problem is still not solved, you may try more cruel solution :

DGMGRL -> disable configuration;
DGMGRL -> enable configuration;