How to fix the Oracle error ORA-16065: remote archival disabled at standby destination?

In this post, you’ll learn more about the Oracle ErrorORA-16065: remote archival disabled at standby destination with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16065: remote archival disabled at standby destination

Reason for the Error ORA-16065: remote archival disabled at standby destination

Receipt of remote archived REDO log files has been disabled at the associated standby destination host database.

How to fix the Error ORA-16065: remote archival disabled at standby destination ?

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

If appropriate change the associated archive log parameter to specify a local destination with the LOCATION keyword or defer the associated archive log destination. Or, if possible, set the standby REMOTE_ARCHIVE_ENABLE parameter to TRUE, or enable the RECEIVE attribute of the LOG_ARCHIVE_CONFIG parameterand restart the standby database instance before further REDO log file archivals occur.

Tags :

Leave Your Comment