Resynchronize data manually

Manual resynchronization involves replacing the inconsistent table in the target database with a copy of the correct table from the reference database.

Important: Manual resynchronization is not recommended for repairing your replicated tables because you must suspend replication to avoid producing further inconsistencies.

The following example shows how to manually resynchronize two replication database servers.

To synchronize the replication server g_papeete with the server g_raratonga:

  1. Suspend replication to the replication server group g_papeete.

    See Suspending Replication for a Server.

  2. Unload the table from the server group g_raratonga.

    See Load and unload data.

  3. Load the table on g_papeete and specify BEGIN WORK WITHOUT REPLICATION.

    See Load and unload data and Blocking Replication.

  4. Resume replication to g_papeete.

    See Resuming a Suspended Replication Server.