DGMGRL> show database 'dsdfdbs';
Database - dsdfdbs
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
dsdfdb
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
Database Status:
WARNING
解决:
报错是因为备库的参数与主库设置的不一致,所以先查看主库的参数
DGMGRL> SHOW DATABASE VERBOSE 'dsdfdbm';
Database - dsdfdbm
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
dsdfdb
Properties:
DGConnectIdentifier = 'dsdfdbm_dgmgrl'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'dsdfdb'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibpsdba)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dsdfdbm_DGMGRL.cuiyan1.com)(INSTANCE_NAME=dsdfdb)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/oracle/arch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
通过查看主库的参数来修改备库的参数数值
DGMGRL> edit database 'dsdfdbs' set property 'ArchiveLagTarget'='0';
DGMGRL> edit database 'dsdfdbs' set property 'LogArchiveMinSucceedDest'='1';
DGMGRL> edit database 'dsdfdbs' set property 'LogArchiveMaxProcesses'='4';
DGMGRL> show database 'dsdfdbs';
Database - dsdfdbs
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
dsdfdb
Database Status:
Database - dsdfdbs
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
dsdfdb
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
Database Status:
WARNING
解决:
报错是因为备库的参数与主库设置的不一致,所以先查看主库的参数
DGMGRL> SHOW DATABASE VERBOSE 'dsdfdbm';
Database - dsdfdbm
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
dsdfdb
Properties:
DGConnectIdentifier = 'dsdfdbm_dgmgrl'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'dsdfdb'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibpsdba)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dsdfdbm_DGMGRL.cuiyan1.com)(INSTANCE_NAME=dsdfdb)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/oracle/arch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
通过查看主库的参数来修改备库的参数数值
DGMGRL> edit database 'dsdfdbs' set property 'ArchiveLagTarget'='0';
DGMGRL> edit database 'dsdfdbs' set property 'LogArchiveMinSucceedDest'='1';
DGMGRL> edit database 'dsdfdbs' set property 'LogArchiveMaxProcesses'='4';
DGMGRL> show database 'dsdfdbs';
Database - dsdfdbs
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
dsdfdb
Database Status:
SUCCESS
类似问题都可以通过这个方法解决。