DGBROKER启用配置失败:ORA-16664

郑全

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

主库查询：

   

• DGMGRL> SHOW CONFIGURATION VERBOSE;
• Configuration - jhemr
• Protection Mode: MaxAvailability
• Databases:
• jhemr_new - Primary database
• jhemr- 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 - jhemr
• Protection Mode: MaxAvailability
• Databases:
• jhemr-new - Primary database
• jhemr - 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 jhemr;
• Database - jhemr
• 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):
• jhemr
• 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 setting
• Warning: ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
• Properties:
• DGConnectIdentifier = 'jhemr'
• ObserverConnectIdentifier = ''
• LogXptMode = 'SYNC'
• DelayMins = '0'
• Binding = 'OPTIONAL'
• MaxFailure = '0'
• MaxConnections = '1'
• ReopenSecs = '300'
• NetTimeout = '30'
• RedoCompression = 'DISABLE'
• LogShipping = 'ON'
• PreferredApplyInstance = ''
• ApplyInstanceTimeout = '0'
• ApplyParallel = 'AUTO'
• StandbyFileManagement = 'AUTO'
• ArchiveLagTarget = '0'
• LogArchiveMaxProcesses = '30'
• LogArchiveMinSucceedDest = '1'
• DbFileNameConvert = '/u02/oradata/jhemr, /u02/oradata/jhemr'
• LogFileNameConvert = '/u02/oradata/jhemr, /u02/oradata/jhemr'
• FastStartFailoverTarget = ''
• InconsistentProperties = '(monitor)'
• InconsistentLogXptProps = '(monitor)'
• SendQEntries = '(monitor)'
• LogXptStatus = '(monitor)'
• RecvQEntries = '(monitor)'
• ApplyLagThreshold = '0'
• TransportLagThreshold = '0'
• TransportDisconnectedThreshold = '30'
• SidName = 'jhemr'
• StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db02)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=jhemr_DGMGRL)(INSTANCE_NAME=jhemr)(SERVER=DEDICATED)))'
• StandbyArchiveLocation = '/u02/archived_log/'
• AlternateLocation = ''
• LogArchiveTrace = '0'
• LogArchiveFormat = '%t_%s_%r.arc'
• TopWaitEvents = '(monitor)'
• Database Status:
• WARNING
• 备库状态报告4个属性值与数据库设置不一致，重新设置
  
  
  
  • DGMGRL> edit database jhemr set property LogArchiveFormat='%t_%s_%r.arc';
  • Property "logarchiveformat" updated
  • DGMGRL> edit database jhemr set property ArchiveLagTarget=0;
  • Property "archivelagtarget" updated
  • DGMGRL> edit database jhemr set property LogArchiveTrace=0;
  • Property "logarchivetrace" updated
  • DGMGRL> edit database jhemr set property LogArchiveMinSucceedDest=1;
  • Property "logarchiveminsucceeddest" updated
  • DGMGRL> show database verbose jhemr;
    
  再次查看broker状态
  
  
  
•   
  
• DGMGRL> SHOW CONFIGURATION VERBOSE;
• Configuration - jhemr
• Protection Mode: MaxAvailability
• Databases:
• jhemr_new - Primary database
• jhemr - Physical standby 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:
• SUCCESS