环境:Oracle linux 5.5+Oracle 11.2.0.2
发现一套1一主二从的Oracle 11.2.0.2主从库的一个active standby无法实时同步。
查看dgmgrl配置没有问题,日志同步状态为实时同步: LogXptMode = 'SYNC'
DGMGRL> show database verbose s2bzcge;
Database - s2bzcge
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
bzcge
Properties:
DGConnectIdentifier = '(description =(address_list =(address = (protocol = tcp)(host = *.*.*.* )(port = 1111)))(connect_data =(service_name = service)))'
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
Database - s2bzcge
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
bzcge
Properties:
DGConnectIdentifier = '(description =(address_list =(address = (protocol = tcp)(host = *.*.*.* )(port = 1111)))(connect_data =(service_name = service)))'
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