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

Solution ID

ORA-16857

Type

Oracle

Arguments

standby disconnected from redo source for longer than specified threshold

---

Cause

The amount of time the standby was disconnected from the redo source database exceeded the value specified by the 'TransportDisconnectedThreshold' database property. It is caused by no network connectivity between the redo source and the standby databases.

Action

Check for gaps on the standby database. If no gap is present, tune the apply services..

 My suggestion is that :

Try setting TransportDisconnectedThreshold higher than the default of 30.

DGMGRL> EDIT DATABASE testfo SET PROPERTY  TransportDisconnectedThreshold='120';

 or if you want to disable alert :

DGMGRL> EDIT DATABASE testfo SET PROPERTY  TransportDisconnectedThreshold='0';

after this you may need to execute this command :

DGMGRL> enable database standbyDB;