How to Resolve ORA-16826: apply service state is inconsistent with the DelayMins property

the data guard incident



DGMGRL> show database standbydb

Database - standb

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       2 minutes 13 seconds
  Real Time Query: OFF
  Instance(s):
    standb1 (apply instance)
    standb2

  Database Warning(s):
    ORA-16826: apply service state is inconsistent with the DelayMins property

Database Status:
WARNING
------------------------------------------------------------------------------------------

 The status was coming to WARNING. I think it's just temporarily inconsistent, the broker will recover itself soon or later. But you still can wake it up manually and simply by re-enabling the standby database.
DGMGRL> enable database standbbydb
Enabled.
DGMGRL> show database standb

Database - standb

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: OFF
  Instance(s):
    standb1 (apply instance)
    standb2

Database Status:
SUCCESS

DGMGRL>

Comments

Post a Comment

Popular posts from this blog

Starting and Stopping Oracle Enterprise Manager Grid Control 11g

Starting and Stopping Oracle Enterprise Manager  Grid Control  11g Before you start your journey to stop the grid control components in sequence, you need to determined where your OMS,recpository DB and grid Agent home path is location on your gridcontrol server. my environment where I have tested this is : orcle db version :Oracle 11.2.0.1.0 - Production gridconrol version :  Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0 o/sys version: RHELinux 5.9 support source: http://docs.oracle.com/cd/E11857_01/index.htm --homes path $cat /etc/oratab  ORCL:/u01/app/oracle/product/11.2.0/dbhome_1:Y OMS:/u01/oracle/Middleware/oms11g:Y AGENT:/u01/oracle/Middleware/agent11g:Y 1. Stopping OMS ... ORACLE_SID = [oracle] ? OMS The Oracle base for ORACLE_HOME=/u01/oracle/Middleware/oms11g is XPointer evaluation failed: no locset [ oracle on pts/2 ] (1004) % emctl stop oms -all         ...
Read more