ORA-16723: setting AlternateLocation property conflicts with the redo transport setting ORACLE 报错 故障修复 远程处理

文档解释

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

Cause: 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.

Action: 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.

ORA-16723是一个数据库错误，指出在设置了redo transport时，设置AlternateLocation属性会冲突。

官方解释

这个错误表明将AlternateLocation属性设置为TRUE（从控制文件中读取重做日志的位置）时，其与使用REDO_TRANSPORT端口参数的配置会冲突。

常见案例

当使用端口参数REDO_TRANSPORT时，系统会默认将AlternateLocation属性设置为FALSE，用于使用指定的重做日志位置（在配置文件设置的端口重做日志的位置）来处理重做日志数据。

一般处理方法及步骤

1.确保REDO_TRANSPORT参数正确设置，并确保端口上套接字文件存在；

2.重置AlternateLocation属性，并将它设置为TRUE；

3.如果需要使用特定的端口重做日志，请确保设置了REDO_TRANSPORT参数；

4.重新启动数据库服务，确保配置文件中的AlternateLocation属性可正确访问。