How to fix the Oracle error ORA-16801: redo transport-related property is inconsistent with database setting?

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

Oracle Error Description

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

Reason for the Error ORA-16801: redo transport-related property is inconsistent with database setting

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.

How to fix the Error ORA-16801: redo transport-related property is inconsistent with database setting ?

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

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.