ORA-16801: redo transport-related property is inconsistent with database setting ORACLE 报错 故障修复 远程处理

文档解释

ORA-16801: redo transport-related property is inconsistent with database setting

Cause: The values of one or more redo transport-related configuration properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by directly altering initialization parameters instead of editing configurable property values using Data Guard broker.

Action: Query the InconsistentLogXptProps property on the primary database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configurable property settings to be propagated to the initialization parameters.

这是一个由Oracle数据库引发的错误消息，表明redo传输相关属性与数据库设置不一致。

可能的原因是：

1. 检查文件，如pfile或spfile，是否配置了支持publicredotransports的参数。如果参数设置正确，但问题仍然存在，那么将其调整到一致的状态，或者删除参数来禁用publicredotransports。

2. 检查/etc/oratab文件中传输字段是否配置正确。如果文件中没有参数，则对其进行设置，以便启用和禁用publicredotransports。

3. 如果上述步骤均未解决问题，建议重新检查设置并通过监听模式启动数据库实例。

通常情况下，处理该错误的步骤是：

1. 执行SQL> alter system set publicredotransports=FALSE scope=spfile;

2. 停止数据库实例并重启它

3. 执行alter system set publicredotransports=TRUE scope=spfile;

4. 重新启动数据库实例。