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

最新推荐文章于 2023-02-23 14:28:44 发布

原创

最新推荐文章于 2023-02-23 14:28:44 发布 · 2.6k 阅读

1 ·

CC 4.0 BY-SA版权

在配置Oracle Data Guard Broker时遇到ORA-16792错误，提示configurable property value与数据库设置不一致。通过连接到物理备库，检查配置状态，发现LogArchiveFormat参数值存在不匹配。通过查询数据库参数和查看Broker日志，确定问题在于LogArchiveFormat的设置。最后，通过DGMGRL更新物理备库的LogArchiveFormat参数，解决了问题。

Data Guard Broker
OEM12C配置管理Data Guard中报错如下：
ORA-16792: configurable property value is inconsistent with database setting

查询错误过程：
1：登录物理备库
$ 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
&