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

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.