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;

  • July 17, 2017 | 13 views
  • Comments