本帖最后由 flzhang 于 2018-2-28 16:13 编辑
我现在的环境是一主一备,一套dataguard,现在用broker管理
主库有时传送日志的时候非常慢。查看主备信息报如下问题
DGMGRL> show database verbose primary;
Database - primary
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
orcl11g
Error: ORA-16737: the redo transport service for standby database "physical" has an error
Properties:
DGConnectIdentifier = 'primary'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u02/oracle/oradata/orcl11g/, /u03_clone/oracle/oradata/orcl11g/'
LogFileNameConvert = '/u02/oracle/oradata/orcl11g/, /u03_clone/oracle/oradata/orcl11g/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'orcl11g'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=iz2zehy7gff0kpg1swp1czz)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PRIMARY_DGMGRL.localdomain)(INSTANCE_NAME=orcl11g)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u02/oracle/oradata/orcl11g/archivelog'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
ERROR
DG