DGMGRL> show configuration;
Configuration - stdby_dgb
Protection Mode: MaxPerformance
Databases:
stdby_db - Primary database
stdby_db3 - Physical standby database
Warning: ORA-16809: multiple warnings detected for the database
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
Database - stdby_db3
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: (unknown)
Real Time Query: ON
Instance(s):
STDBY1
Warning: ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
STDBY2
Warning: ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
STDBY3 (apply instance)
Warning: ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
Properties:
DGConnectIdentifier = 'stdbyhost-scan:1522/STDBY_db3'
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 = '+FRA/stdby_db, +FRA/stdby_db3/, +DATA/stdby_db/, +DATA/stdby_db3/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName()
StaticConnectIdentifier(
StaticConnectIdentifier()
StandbyArchiveLocation()
AlternateLocation(
AlternateLocation()
LogArchiveTrace()
LogArchiveFormat(
LogArchiveFormat()
TopWaitEvents()
(
() - Please check specific instance for the property value
Database Status:
WARNING
DGMGRL> show database stdby_db3 statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
STDBY1 WARNING ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
STDBY3 WARNING ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
STDBY3 WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
STDBY2 WARNING ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
STDBY_db3 SQL> SHOW PARAMETER db_file_name_convert;
NAME TYPE VALUE
db_file_name_convert string +DATA/stdby_db/, +DATA/stdby_db3/
Property "dbfilenameconvert" updated
Enabled.
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
Configuration - stdby_dgb
Protection Mode: MaxPerformance
Databases:
stdby_db - Primary database
stdby_db3 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
0 comments:
Post a Comment