How to fix the Oracle error ORA-16857: standby disconnected from redo source for longer than specified threshold?

In this post, you’ll learn more about the Oracle ErrorORA-16857: standby disconnected from redo source for longer than specified threshold with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error ORA-16857: standby disconnected from redo source for longer than specified threshold ?

You can fix this error in Oracle by following the below steps

Ensure that there is network connectivity between the redo source and standby databases, and the redo source is working properly.