Data Guard Broker

ORA-16792: configurable property value is inconsistent with database setting

$ dgmgrl
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration;
Configuration - palm_prim
Protection Mode: MaxPerformance
Databases:
palm_prim - Primary database
palm_stdy - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with database setting
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> show database palm_prim statusreport;
STATUS REPORT
INSTANCE_NAME   SEVERITY ERROR_TEXT
DGMGRL> show database palm_stdy statusreport;
STATUS REPORT
INSTANCE_NAME   SEVERITY ERROR_TEXT
palm    WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting

SQL> show parameter Format
NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_format                   string                 %t_%s_%r.dbf

Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='', SPFILE='', DATABASE='%t_%s_%r.dbf'

DGMGRL> edit database palm_stdy set property LogArchiveFormat='%t_%s_%r.dbf';
Property "logarchiveformat" updated
DGMGRL>
DGMGRL> show database palm_stdy statusreport;
STATUS REPORT
INSTANCE_NAME   SEVERITY ERROR_TEXT
————————————————

Error Id: ORA-16714

Title: the value of property string is inconsistent with the database setting

Description:

the value of property string is inconsistent with the database setting

Action:

Query property InconsistentProperties on the database to determine the inconsistent values. Reset the property to make it consistent with the database setting.

Cause:

The value of the specified configuration property is inconsistent with database in-memory settings or server parameter file settings. This may be caused by changing an initialization parameter that corresponds to a configuration property.

Error Id: ORA-16792

Title: configuration property value is inconsistent with database setting

Description:

configuration property value is inconsistent with database setting

Action:

Query property the InconsistentProperties on the 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 configuration property settings to be propagated to to the initialization parameters.

Cause:

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

-- 来自：