这篇文章主要介绍oracle12c broker ArchiveLagTarget不一致怎么办，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！
在配置了brokger的dg环境下，一定要用broker 去调整相关参数，切记。
1、查看DG状态，发现有告警 DGMGRL> show database orcldg; Database - orcldg Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 0 seconds ago) Apply Lag: 0 seconds (computed 0 seconds ago) Average Apply Rate: 7.00 KByte/s Real Time Query: OFF Instance(s): orcldg Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting Database Status: WARNING 2、查看不一致参数，broker里的值为0，参数文件里为60 DGMGRL> show database orcldg inconsistentProperties; INCONSISTENT PROPERTIES INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE orcldg ArchiveLagTarget 60 60 0 3、确认参数文件里的参数 SQL> show parameter archive_lag NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 60 SQL> 4、使用broker修改参数 DGMGRL> edit database orcldg SET PROPERTY ArchiveLagTarget=0; Property "archivelagtarget" updated DGMGRL> 5、查看DG状态,告警无 DGMGRL> show database orcldg; Database - orcldg Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 6.00 KByte/s Real Time Query: OFF Instance(s): orcldg Database Status: SUCCESS DGMGRL>
以上是“oracle12c broker ArchiveLagTarget不一致怎么办”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
