Site Priority CDR

Note:

SITE PRIORITY resolution takes precedence over all COLUMN GROUP resolution settings.

Note:

If SITE PRIORITY Replicat parameter is not placed before applicable map statements in the parameter file, it will not work. This parameter must be placed before the applicable map statements.

Priority resolution is specified in Replicat parameter file between source and target for conflict resolution.

SITE PRIORITY is enabled for a database or PDB in the Replicat parameter file with the parameter ACDR SITE_PRIORITY {source_db_name}{OVERWRITE | IGNORE }, which is specified to turn on SITE PRIORITY resolution for a table.

If the OVERWRITE option is specified, then the source table takes priority and conflicts are resolved by OVERWRITE. Conversely, if the IGNORE option is specified, then the target table takes priority and the source table changes are ignored in a conflict.

SITE PRIORITY resolution can be disabled by the field ADDITIONAL_OPTIONS in the ADD_AUTO_CDR() procedure in DBMS_GOLDENGATE_ADM package, and ALTER_AUTO_CDR() by setting IGNORE_SITE_PRIORITY.

Every Replicat source-target relationship can be set up differently, therefore, convergence is dependent on user setup.