DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 4, 2017

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

No comments: