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


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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google