Dataguard parameter inconsistency

If we update certain parameter in database directly using:

alter system set <parameter> to <value>;

This can cause Dataguard some issues as the broker keeps its own value of certain parameters, if you have this issue can use below to fix as an example:

  • dgmgrl /
  • show configuration;
  • show database ‘<issue db> InconsistentProperties

example below:

DGMGRL> show database ‘dbahelpA’ InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
dbahelpA1 LogArchiveMaxProcesses 5 5 4
dbahelpA2 LogArchiveMaxProcesses 5 5 4

Fix:

DGMGRL> edit database dbahelpA set property LogArchiveMaxProcesses=5;
Property “logarchivemaxprocesses” updated