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

advertisements

_____________________________________________________________________________________________________________________

Error Description:

Show configuration command shows following warning in DGMGRL.

 

DGMGRL> show configuration

 

Configuration - PRDCONFIG

 

  Protection Mode: MaxAvailability

  Databases:

    TRANPRD         - Primary database

    TRANPRD_STANDBY - Physical standby database

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

 

Fast-Start Failover: DISABLED

 

Configuration Status:

WARNING

Solution Description

The error is because of the mismatch with thedelaymins property of the data guard.

DGMGRL> show database verbose 'TRANPRD_STANDBY';

 

Database - TRANPRD_STANDBY

 

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: OFF

  Instance(s):

    TRANPRD_STANDBY

 

  Properties:

    DGConnectIdentifier             = 'TRANPRD_standby'

    ObserverConnectIdentifier       = ''

    LogXptMode                      = 'SYNC'

    DelayMins                       = '0'

 

You have to run the following command to fix this warning.

SQL> alter database recover managed standby database cancel;

 

Database altered.

 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

 

Database altered.

_____________________________________________________________________________________________________________________

Website Stats