Remastering replicates without name verification

You manually remaster replicates if the participants to not have matching column names and replicate has name verification turned off by the --name=n option of the cdr define replicate command.

Procedure

To manually remaster a replicate:
  1. Use the cdr define replicate command to create a shadow replicate with the same attributes as the primary replicate and with the --mirrors option, but with a SELECT statement that is correct for the table after the alter operation. The SELECT statement can include newly added columns or omit newly dropped columns.
  2. Use the cdr swap shadow command to exchange the existing primary replicate and the newly created shadow replicate.

Results

While performing the cdr swap shadow operation, Enterprise Replication stores the BEGIN WORK position of the last known transaction sent to the grouper as a swap log position for the current swap operation. Any transaction that is begun before the swap log position uses the original replicate definition. Any transaction that is begun after the swap log position uses the new replicate definition.

The old replicate definition is deleted automatically after the replicate definition is no longer required by Enterprise Replication.