DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 17, 2017

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

Issue:

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

Reason:

This is because of the wrong configuration to time delay paramater in dataguard

Work around:

Please refere < Doc ID 249703.1>

DGMGRL> edit database <standby database> set state=apply-off;
DGMGRL> edit database <standby database> set state=apply-on;

or

SQL>alter database recover managed standby database cancel;

SQL> alter database recover managed standby database using current logfile disconnect;

No comments: