Tuesday, October 18, 2016

Warning: ORA-16829: fast-start failover configuration is lagging

Automatic failover caused DR to become primary and primary to become DR, but when checked the dgmgrl configuration there were some errors.

$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration

Configuration - db1tes_dg

  Protection Mode: MaxPerformance
  Databases:
    db1tesd - Primary database
      Warning: ORA-16829: fast-start failover configuration is lagging

    db1tesp - (*) Physical standby database
      Error: ORA-16810: multiple errors or warnings detected for the database

Fast-Start Failover: ENABLED

Configuration Status:
ERROR

DGMGRL>

DGMGRL> show database db1tesd

Database - db1tesd

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    db1tesd1

  Database Warning(s):
    ORA-16829: fast-start failover configuration is lagging

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database db1tesp

Database - db1tesp

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   (unknown)
  Apply Lag:       3 hours 20 minutes 3 seconds
  Real Time Query: ON
  Instance(s):
    db1tesp1 (apply instance)
    db1tesp2

  Database Warning(s):
    ORA-16826: apply service state is inconsistent with the DelayMins property
    ORA-16829: fast-start failover configuration is lagging

Database Status:
WARNING

DGMGRL>

Fix:

What I did in our case was simply restarted the the new DR and it fixed the issue.

$ srvctl stop database -d db1tesp
$ srvctl start database -d db1tesp


$ dgmgrl 
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration

Configuration - db1tes_dg

  Protection Mode: MaxPerformance
  Databases:
    db1tesd - Primary database
    db1tesp - (*) Physical standby database

Fast-Start Failover: ENABLED

Configuration Status:
SUCCESS

DGMGRL> 
DGMGRL> 
DGMGRL> show database db1tesp

Database - db1tesp

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

Database Status:
SUCCESS

DGMGRL> show database db1tesd

Database - db1tesd

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    db1tesd1

Database Status:
SUCCESS

DGMGRL> 


No comments: