文档解释
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.
ORA-16826错误指出应用服务状态与延迟分钟属性(DelayMins)不相符。
错误信息:
ORA-16826:ERROR:The apply service state is inconsistent with the DelayMins property.
ORA-06512: at “SYS.DBMS_APPLY_ADM”, line 298
ORA-06512: at “SYS.DBMS_APPLY_ADM”, line 777
此错误通常意味着apply服务的当前状态与用户设置的延时分钟数不一致。
官方解释
这个错误将给出详细的信息,指出应用服务的状态与delayMins属性不一致。delayMins属性的设置和应用实施的状态必须匹配。
常见案例
1.用户设置了某个apply服务的延迟分钟属性(Database Apply),但这个服务当前处于禁用状态(DISABLED),此时就会出现ORA-16826错误。
2.用户尝试将DISABLED状态下的apply服务,重新启用,但如果还没有清除延迟分钟属性,那么也会报ORA-16826错误。
一般处理方法及步骤
1. 首先确保要改变的apply服务处于正常状态,即服务当前处于ENABLED状态;
2. 然后确认delayMins属性是否保持默认状态,或者设置为零;
3. 如果上述步骤没有解决问题,则可以使用dbms_apply_adm.alter_apply把apply服务置于可被修改的状态;
4. 之后使用dbms_apply_adm.alter_apply_params设置delayMins属性,然后再重新启用apply服务;
5. 最后重新启动数据库及其apply服务,查看错误是否已经解决。