DataGuard Issues

DataGuard Issues

1):

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

Workaround:

Check DG configuration:

DGMGRL> show configuration

Configuration - ZEE_DG_CONFIG

  Protection Mode: MaxPerformance
  Databases:
    zee   - Primary database
    zeedr - Physical standby database
      Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Fast-Start Failover: DISABLED

Configuration Status:

WARNING

Check on Which node MRP process is running.

On Standby

Make sure  Standby redo logs files are created on standby.

Please refere < Doc ID 249703.1> for the same.

DGMGRL> edit database <STANDBY DB> set state=apply-off;

DGMGRL> edit database <STANDBY DB> set state=apply-on;

OR

SQL>alter database recover managed standby database cancel;

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

Verify DG Broker Configuration:

DGMGRL> show configuration

Configuration - ZEE_DG_CONFIG

  Protection Mode: MaxPerformance

  Databases:

    zee   - Primary database

    zeedr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

---------------------------------------------------------

DGMGRL> show database zeedr

Database - zeedr

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: OFF

  Instance(s):

    zee

Database Status:

SUCCESS

How to avoid this issue:

1. This Problem can only happen if Managed Recovery is started manually which should not be done at 

all if there is an active Data Guard Broker Configuration - reference Doc ID 249703.1 Typically the 

Data Guard Broker should start Managed Recovery.

2. It can also happen if there are no Standby RedoLogs in Place or they are incorrectly configured

- reference Doc ID 219344.1 to set them up.