Saturday, February 21, 2026

11g Broker ORA-16809, ORA-16714: the value of property DbFileNameConvert is inconsistent

 
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
 
DGMGRL> show database verbose stdby_db3;
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
 
 
From STANDBY DB

STDBY_db3 SQL> SHOW PARAMETER db_file_name_convert;
NAME TYPE VALUE
db_file_name_convert string +DATA/stdby_db/, +DATA/stdby_db3/
 
FIX
 
DGMGRL> edit database stdby_db3 set property DbFileNameConvert ='+DATA/stdby_db/,+DATA/stdby_db3/';
Property "dbfilenameconvert" updated
 
DGMGRL> enable database stdby_db3;
Enabled.
 
DGMGRL> show database stdby_db3 statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
 
DGMGRL> show configuration;
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

Auto Scroll Stop Scroll