配置完dg broker报如下错误：
DGMGRL> show database jzhdg
Database - jzhdg
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: 0 Byte/s
Real Time Query: OFF
Instance(s):
jzh
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses 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
Database Status:
WARNING
发现spfile_value 值都为空
DGMGRL> SHOW DATABASE 'jzhdg' 'InconsistentProperties';
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
jzh ArchiveLagTarget 0 0
jzh LogArchiveMaxProcesses 4 4
jzh LogArchiveMinSucceedDest 1 1
jzh LogArchiveTrace 0 (missing) 0
jzh LogArchiveFormat %t_%s_%r.dbf (missing) %t_%s_%r.dbf

修改如下：
DGMGRL> edit database 'jzhdg' set property 'LogArchiveFormat'='%t_%s_%r.dbf';
DGMGRL> edit database 'jzhdg' set property 'LogArchiveTrace'='';
Property "LogArchiveTrace" updated
DGMGRL> edit database 'jzhdg' set property 'LogArchiveMinSucceedDest'=1;
Property "LogArchiveMinSucceedDest" updated
DGMGRL> edit database 'jzhdg' set property 'LogArchiveMaxProcesses'=4;
Property "LogArchiveMaxProcesses" updated
DGMGRL> edit database 'jzhdg' set property 'ArchiveLagTarget'='';
Property "ArchiveLagTarget" updated

DGMGRL> SHOW DATABASE 'jzhdg' 'InconsistentProperties';
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
DGMGRL> show database verbose jzhdg
Database - jzhdg
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: 0 Byte/s
Real Time Query: OFF
Instance(s):
jzh
Properties:
DGConnectIdentifier = 'jzhdg'
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 = ''
LogFileNameConvert = 'jzh, jzhdg'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'jzh'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=jzhdg_DGMGRL)(INSTANCE_NAME=jzh)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/arch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS

ITPub博客

Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent

最新文章