DG: Finding and fixing inconsistencies

To view DG inconsistencies, for example when errors ORA-16792 are being returned.

$ dgmgrl / "show far_sync emdev13ce 'InconsistentProperties'"
...
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME          MEMORY_VALUE SPFILE_VALUE BROKER_VALUE 
emdev13c      LogArchiveMaxProcesses  4                        4 
emdev13c     LogArchiveMinSucceedDest 1                        1

 

To correct them:

$ sqlplus / as sysdba
SQL> alter system set log_archive_max_processes=4 scope=both;
System altered.
SQL> alter system set log_archive_min_succeed_dest=1 scope=both;
System altered.
SQL>

 

To check again:

$ dgmgrl / "show far_sync emdev13ce 'InconsistentProperties'"
...
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE