Data Guard配置Broker解决ORA-16664、ORA-16792

这篇博客详细记录了在配置Oracle Data Guard时遇到的ORA-16664和ORA-16792错误的解决过程。通过`SHOW CONFIGURATION VERBOSE`命令检查配置状态,发现警告和错误信息。通过编辑数据库属性,如`LogArchiveFormat`、`ArchiveLagTarget`、`LogArchiveTrace`和`LogArchiveMinSucceedDest`,并调整相关设置,最终成功解决这些问题,使配置状态变为SUCCESS。
摘要由CSDN通过智能技术生成
给某一个客户安装ADG完毕,配置Broker方便日后的管理与切换,碰到些许问题,以作记录

创建完configuration之后,enable的过程很慢,而且状态出现error

主库查询:

  1. DGMGRL> SHOW CONFIGURATION VERBOSE;
  2. Configuration - anxinconf
  3. Protection Mode: MaxAvailability
  4. Databases:
  5. anxin - Primary database
  6. anxinstd - Physical standby database
  7. Error: ORA-16664: unable to receive the result from a database
  8. Properties:
  9. FastStartFailoverThreshold = '30'
  10. OperationTimeout = '30'
  11. FastStartFailoverLagLimit = '30'
  12. CommunicationTimeout = '180'
  13. ObserverReconnect = '0'
  14. FastStartFailoverAutoReinstate = 'TRUE'
  15. FastStartFailoverPmyShutdown = 'TRUE'
  16. BystandersFollowRoleChange = 'ALL'
  17. ObserverOverride = 'FALSE'
  18. ExternalDestination1 = ''
  19. ExternalDestination2 = ''
  20. PrimaryLostWriteAction = 'CONTINUE'
  21. Fast-Start Failover: DISABLED
  22. Configuration Status:
  23. ERROR
备库查询:

  1. DGMGRL> SHOW CONFIGURATION VERBOSE;
  2. Configuration - anxinconf
  3. Protection Mode: MaxAvailability
  4. Databases:
  5. anxin - Primary database
  6. anxinstd - Physical standby database
  7. Warning: ORA-16792: configurable property value is inconsistent with database setting
  8. Properties:
  9. FastStartFailoverThreshold = '30'
  10. OperationTimeout = '30'
  11. FastStartFailoverLagLimit = '30'
  12. CommunicationTimeout = '180'
  13. ObserverReconnect = '0'
  14. FastStartFailoverAutoReinstate = 'TRUE'
  15. FastStartFailoverPmyShutdown = 'TRUE'
  16. BystandersFollowRoleChange = 'ALL'
  17. ObserverOverride = 'FALSE'
  18. ExternalDestination1 = ''
  19. ExternalDestination2 = ''
  20. PrimaryLostWriteAction = 'CONTINUE'
  21. Fast-Start Failover: DISABLED
  22. Configuration Status:
  23. WARNING
查看备数据库的状态

  1. DGMGRL> show database verbose anxinstd;
  2. Database - anxinstd
  3. Role: PHYSICAL STANDBY
  4. Intended State: APPLY-ON
  5. Transport Lag: 0 seconds (computed 1 second ago)
  6. Apply Lag: 0 seconds (computed 1 second ago)
  7. Apply Rate: 54.00 KByte/s
  8. Real Time Query: ON
  9. Instance(s):
  10. anxinstd
  11. Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
  12. Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
  13. Warning: ORA-16714: the value of property LogArchiveTrace is inconsistent with the database sett
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值