给某一个客户安装ADG完毕,配置Broker方便日后的管理与切换,碰到些许问题,以作记录
创建完configuration之后,enable的过程很慢,而且状态出现error
主库查询:
备库查询:
查看备数据库的状态
创建完configuration之后,enable的过程很慢,而且状态出现error
主库查询:
- DGMGRL> SHOW CONFIGURATION VERBOSE;
- Configuration - anxinconf
- Protection Mode: MaxAvailability
- Databases:
- anxin - Primary database
- anxinstd - Physical standby database
- Error: ORA-16664: unable to receive the result from a database
- Properties:
- FastStartFailoverThreshold = '30'
- OperationTimeout = '30'
- FastStartFailoverLagLimit = '30'
- CommunicationTimeout = '180'
- ObserverReconnect = '0'
- FastStartFailoverAutoReinstate = 'TRUE'
- FastStartFailoverPmyShutdown = 'TRUE'
- BystandersFollowRoleChange = 'ALL'
- ObserverOverride = 'FALSE'
- ExternalDestination1 = ''
- ExternalDestination2 = ''
- PrimaryLostWriteAction = 'CONTINUE'
- Fast-Start Failover: DISABLED
- Configuration Status:
- ERROR
- DGMGRL> SHOW CONFIGURATION VERBOSE;
- Configuration - anxinconf
- Protection Mode: MaxAvailability
- Databases:
- anxin - Primary database
- anxinstd - Physical standby database
- Warning: ORA-16792: configurable property value is inconsistent with database setting
- Properties:
- FastStartFailoverThreshold = '30'
- OperationTimeout = '30'
- FastStartFailoverLagLimit = '30'
- CommunicationTimeout = '180'
- ObserverReconnect = '0'
- FastStartFailoverAutoReinstate = 'TRUE'
- FastStartFailoverPmyShutdown = 'TRUE'
- BystandersFollowRoleChange = 'ALL'
- ObserverOverride = 'FALSE'
- ExternalDestination1 = ''
- ExternalDestination2 = ''
- PrimaryLostWriteAction = 'CONTINUE'
- Fast-Start Failover: DISABLED
- Configuration Status:
- WARNING
- DGMGRL> show database verbose anxinstd;
- Database - anxinstd
- Role: PHYSICAL STANDBY
- Intended State: APPLY-ON
- Transport Lag: 0 seconds (computed 1 second ago)
- Apply Lag: 0 seconds (computed 1 second ago)
- Apply Rate: 54.00 KByte/s
- Real Time Query: ON
- Instance(s):
- anxinstd
- Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
- Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
- Warning: ORA-16714: the value of property LogArchiveTrace is inconsistent with the database sett