ORA-16826: apply service state is inconsistent with the DelayMins
Error:
Warning from DGBroker service regarding error
ORA-16826: apply service state is inconsistent with the DelayMins property
DGMGRL> show database standb
Database - ORCL
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 12 minutes 11 seconds
Real Time Query: OFF
Instance(s):
ORCL1 (apply instance)
ORCL2
Database Warning(s):
ORA-16826: apply service state is inconsistent with the DelayMins property
Database Status:
WARNING
Cause:
Sometime DGBROKER Service is not consistent you have to wait or try to reenable it will fix the issue.
Solution
Enable the Standby Service again by DGBrokcer OR Manually stop and restart the Service from SQLPLUS
Manually stop and start from SQLPLUS
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.
Enable from DGBROKER
DGMGRL> enable database ORCL
Enabled.
Verify the Configuration of STANDBY database
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):
orcl1 (apply instance)
orcl2
Database Status:
SUCCESS
Error explained from Oracle
C:\Oracle\dbhomeXE\bin>oerr ora 16826
16826, 00000, "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.