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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

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

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer