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