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

给某一个客户安装ADG完毕，配置Broker方便日后的管理与切换，碰到些许问题，以作记录

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

主库查询：

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

备库查询：

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

查看备数据库的状态

1. DGMGRL> show database verbose anxinstd;
3. Database - anxinstd
5. Role: PHYSICAL STANDBY
6. Intended State: APPLY-ON
7. Transport Lag: 0 seconds (computed 1 second ago)
8. Apply Lag: 0 seconds (computed 1 second ago)
9. Apply Rate: 54.00 KByte/s
10. Real Time Query: ON
11. Instance(s):
12. anxinstd
13. Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
14. Warning: ORA-16714: the value of property LogArchiveMinSuccee