Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent
配置完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
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部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-2147327/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Warning: ORA-16792: configurable property value is inconsistent with member sett
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- How to update BOL entity property value via ABAP code
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- Not-null property references a transient value - transient instance must be saved before current opeNull
- [Vue warn]: The data property "dialogVisible" is already declared as a prop. Use prop default valueVue
- TabError: inconsistent use of tabs and spaces in indentationError
- spring aop The hierarchy of the type is inconsistentSpring
- AndroidStudio之自定義輸出包名報錯 Cannot set the value of read-only property 'outputFile' forAndroid
- OCR integrity results are inconsistent amongst the nodes.
- mysql WarningMySql
- Property屬性
- iOS面試之@propertyiOS面試
- 類的property特性
- vue-property-decoratorVue
- Objective-C PropertyObject
- inconsistent datatypes: expected - got CLOB錯誤一例Go
- LOW_VALUE、HIGH_VALUE、ENDPOINT_VALUE轉換--UTL_RAW、DBMS_STATS.CONVERT_RAW_VALUE
- Python @property 詳解Python
- Cannot set property 'innerHTML' of nullHTMLNull
- 交易資訊被篡改 錯誤碼:CONTEXT_INCONSISTENTContext
- 分析函式——FIRST_VALUE()和LAST_VALUE()函式AST
- [WARNING] warning: Class com.google.protobuf.Descriptors not found - continuing with a stub.GoUI
- new_value
- webstorm(二):拼寫warningWebORM
- InnoDB: Warning: a long semaphore waiAI
- CSS3 transition-propertyCSSS3
- Need to set ‘serverTimezone‘ propertyServer
- Cannot set property ‘type‘ of null(vue)NullVue
- TypeScript Crash Course: Property Access ModifiersTypeScript
- attribute和property區別
- javascript array.property.slice.callJavaScript
- @property中的變數與_變數
- Property 與 Attribute 區別
- ERROR: The LVM time stamp for shared volume group: datavg is inconsistentErrorLVM
- Oracle分析函式-first_value()和last_value()Oracle函式AST
- ubuntu下hadoop0.20.2報錯/dfs/name is in an inconsistent stateUbuntuHadoop
- JavaScript select valueJavaScript