Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold in DGB SETUP

Please follow the below steps to resolve.

From within DGMGRL utility I get the following error, on a regular basis.

DGMGRL> show configuration

Configuration – data_dg_config

  Protection Mode: MaxPerformance
  Databases:
    data_dgs – Primary database
    data_dgp – Physical standby database

      Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold

Fast-Start Failover: DISABLED

Configuration Status:
WARNING




After sometime if i ran the same it seems to be fine.

DGMGRL> show configuration

Configuration – data_dg_config

  Protection Mode: MaxPerformance
  Databases:
    data_dgs – Primary database
    data_dgp – Physical standby database
     
Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

This error disappears for a few seconds. Then if I retype ‘show configuration’ it pops up again, and so on..
Please find the below fix.
  • To increase  TransportDisconnectedThreshold database property:
    DGMGRL> EDIT DATABASE testfo SET PROPERTY TransportDisconnectedThreshold=’120′;


  • SOLUTION – Setting ‘TransportDisconnectedThreshold’ to 0 seconds will disable the alert. Alternatively we can set the property to a higher value
  • April 3, 2017 | 14 views