Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Request solution for ORA-16826

667381Oct 27 2008 — edited May 29 2009
In the physical standby database drcXXXXXX.log,there are lot of warning messages:

DG 2008-10-27-12:28:46 0 2 663690199 Operation CTL_GET_STATUS continuing with warning, status = ORA-16826
DG 2008-10-27-12:28:46 0 2 663690199 Operation CTL_GET_STATUS continuing with warning, status = ORA-16826
DG 2008-10-27-12:29:46 0 2 0 RSM: Redo Apply is running without USING CURRENT LOGFILE option while DelayMins=0
DG 2008-10-27-12:29:46 0 2 0 RSM0: HEALTH CHECK WARNING: ORA-16826: apply service state is inconsistent with the DelayMins property
DG 2008-10-27-12:29:46 0 2 663690216 Operation CTL_GET_STATUS continuing with warning, status = ORA-16826
DG 2008-10-27-12:29:46 0 2 663690216 Operation CTL_GET_STATUS continuing with warning, status = ORA-16826

In the primary database alert log and physical standby database alert log, there is no error message at the time (2008-10-27-12:29).

when I run:
select * from V$archive_Gap
there is no record selected.

From Oracle suggestion:

ORA-16826: apply service state is inconsistent with the DelayMins property
Cause: This warning was caused by one of the following reasons:
1. Apply service was started without specifying the real time apply option or without the NODELAY option while DelayMins is zero.

2. Apply service was started with the real-time apply option or with the NODELAY option while DelayMins is 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.


I am not sure how to "Reenable the standby database to allow the broker to restart the apply service with the apply options"

Could you please give some comment?
Thank you very much,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2009
Added on Oct 27 2008
7 comments
12,441 views