Skip to content

ORA-16792: configurable property value is inconsistent with member setting

Problem:

ORA-16792: configurable property value is inconsistent with member setting

DGMGRL> show database stby

Database – stby

Role: PHYSICAL STANDBY
Intended State: APPLY-ON

Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: OFF
Instance(s):
rmnpcmdn_1
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveTrace is inconsistent with the member setting
Warning: ORA-16675: database instance restart required for property value modification to take effect
Warning: ORA-16714: the value of property LogArchiveFormat is inconsistent with the member setting

Database Status:
WARNING

Solution:

modify property using sqlplus or dgmgrl

DGMGRL> show database stby ‘InconsistentProperties’;
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
rmnpcmdn_1 ArchiveLagTarget 0 0
rmnpcmdn_1 LogArchiveMaxProcesses 4 4
rmnpcmdn_1 LogArchiveMinSucceedDest 1 1
rmnpcmdn_1 DataGuardSyncLatency 0 0
rmnpcmdn_1 LogArchiveTrace 0 (missing) 0
rmnpcmdn_1 LogArchiveFormat %t_%s_%r.dbf (missing) %t_%s_%r.dbf

DGMGRL> edit database stby set property ‘LogArchiveTrace’=0;

Property “LogArchiveTrace” updated

DGMGRL> edit database stby set property ‘ArchiveLagTarget’=0;
Property “ArchiveLagTarget” updated
DGMGRL> edit database stby set property ‘LogArchiveMaxProcesses’=4;
Property “LogArchiveMaxProcesses” updated
DGMGRL> edit database stby set property ‘LogArchiveMinSucceedDest’=1;
Property “LogArchiveMinSucceedDest” updated
DGMGRL> edit database stby set property ‘DataGuardSyncLatency’=0;
Property “DataGuardSyncLatency” updated

DGMGRL> edit database stby set property ‘LogArchiveFormat’=’%t_%s_%r.dbf’;
Warning: ORA-16675: database instance restart required for property value modification to take effect

Property “LogArchiveFormat” updated
DGMGRL> show database stby ‘InconsistentProperties’;
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE

DGMGRL> show configuration;

Configuration – dg_prmy_config

Protection Mode: MaxPerformance
Members:
prmy – Primary database
stby – Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 14 seconds ago)

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: