How to fix the Oracle error ORA-16826: apply service state is inconsistent with the DelayMins property?

In this post, you’ll learn more about the Oracle ErrorORA-16826: apply service state is inconsistent with the DelayMins property with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error ORA-16826: apply service state is inconsistent with the DelayMins property ?

You can fix this error in Oracle by following the below steps

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.