How to fix the Oracle error ORA-16723: setting AlternateLocation property conflicts with the redo transport setting?

In this post, you’ll learn more about the Oracle ErrorORA-16723: setting AlternateLocation property conflicts with the redo transport setting with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16723: setting AlternateLocation property conflicts with the redo transport setting

Reason for the Error ORA-16723: setting AlternateLocation property conflicts with the redo transport setting

The standby database was not using standby redo logs, and the redo transport service to the standby database is set to a nonzero value for the ReopenSecs property and a value of zero for the MaxFailure property. In this case, the redo transport service will attempt to send redo data to the standby database indefinitely and never switch to the alternate destination.

How to fix the Error ORA-16723: setting AlternateLocation property conflicts with the redo transport setting ?

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

Any one of the following actions will solve the problem:

– add standby redo logs to the standby database.

– set ReopenSecs property to zero.

– set MaxFailure property to a nonzero value. After performing one of the above actions, reset the standby database AlternateLocation property.