Warning: ORA-16714: Some Parameter are inconsistent with the database setting

This tutorial explains the DGMGRL steps to check and update inconsistent parameter within Oracle RAC.

  • Check the database status.
  • Check parameters.
  • Update DGMGRL parameter

1.Check the database status

DGMGRL> show database verbose wadodb;
Database - wadodb
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
WADODB1
Warning: ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
Warning: ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
WADODB2 Warning: ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting Warning: ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
DGMGRL>

2. Check the parameters:

DGMGRL> show database wadodb inconsistentproperties ;
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
WADODB2 StandbyArchiveLocation /orabackup/WADODB/archiveLog USE_DB_RECOVERY_FILE_DEST
WADODB2 AlternateLocation (missing StandbArchiveLocation setting)
WADODB1 StandbyArchiveLocation /orabackup/WADODB/archiveLog USE_DB_RECOVERY_FILE_DEST
WADODB1 AlternateLocation (missing StandbArchiveLocation setting)


DGMGRL> show database wadodb StandbyArchiveLocation;
Error: ORA-16606: unable to find property "standbyarchivelocation"
DGMGRL> edit database wadodb set property StandbyArchiveLocation='/orabackup/WADODB/archiveLog';
Error: ORA-16587: ambiguous object specified to Data Guard broker
Failed.

3. Update DGMGRL parameter:

Edit parameter for both instances, should be the same configuration as it is a RAC.

DGMGRL> edit instance "WADODB1" on database wadodb set property StandbyArchiveLocation='/orabackup/WADODB/archiveLog';
Property "standbyarchivelocation" updated
DGMGRL>
DGMGRL> edit instance "WADODB2" on database wadodb set property StandbyArchiveLocation='/orabackup/WADODB/archiveLog';
Property "standbyarchivelocation" updated

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.