Role: LOGICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Instance(s):
jadl11g
Properties:
DGConnectIdentifier ='sjadl11g'
ObserverConnectIdentifier =''
LogXptMode = 'ASYNC'
DelayMins ='0'
Binding ='optional'
MaxFailure ='0'
MaxConnections ='1'
ReopenSecs ='300'
NetTimeout ='30'
RedoCompression ='DISABLE'
LogShipping ='ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout ='0'
LsbyASkipTxnCfgPr ='0,0,0'
LsbyDSkipTxnCfgPr ='0,0,0'
LsbyASkipCfgPr =''
LsbyDSkipCfgPr =''
LsbyASkipErrorCfgPr = ''
LsbyDSkipErrorCfgPr =''
LsbyMaxEventsRecorded ='0'
LsbyPreserveCommitOrder =''
LsbyRecordSkipErrors =''
LsbyRecordSkipDdl =''
LsbyRecordAppliedDdl =''
ArchiveLagTarget ='0'
LogArchiveMaxProcesses ='4'
LogArchiveMinSucceedDest ='1'
FastStartFailoverTarget =''
InconsistentProperties ='(monitor)'
InconsistentLogXptProps ='(monitor)'
SendQEntries ='(monitor)'
LogXptStatus ='(monitor)'
RecvQEntries ='(monitor)'
LsbyParameters ='(monitor)'
LsbySkipTxnTable ='(monitor)'
LsbySkipTable ='(monitor)'
LsbyFailedTxnInfo ='(monitor)'
SidName ='jadl11g'
StaticConnectIdentifier ='(DESCRIPTION=(ADDRESS=(PROTOCOL=tc =localhost.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sjadl11g_D INSTANCE_NAME=jadl11g)(SERVER=DEDICATED)))'
StandbyArchiveLocation ='USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace ='0'
LogArchiveFormat ='%t_%s_%r.dbf'
LsbyMaxSga ='0'
LsbyMaxServers ='0'
TopWaitEvents ='(monitor)'
Database Status:
SUCCESS
DGMGRL> edit database sjadl11g set propertylogxptmode='sync';---修改参数
Property"logxptmode" updated