Resynchronizing Data Manually

Manual resynchronization 4involves replacing the inconsistent table in the target database with a copy 4of the correct table from the reference database. Manual resynchronization 4is the least preferred method to repair your replicated tables because you 4must suspend replication to avoid producing further inconsistencies.

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

4To synchronize the replication server g_papeete with the server 4g_raratonga 4

Suspend replication to the replication server group g_papeete. 4
See Suspending Replication for a Server.

Unload the table from the server group g_raratonga. 4 4
See Loading 4and Unloading Data.

Load the table on g_papeete and specify BEGIN WORK 4WITHOUT REPLICATION. 4
See Loading 4and Unloading Data and Blocking Replication.

Resume replication to g_papeete. 4
See Resuming a Suspended 4Replication Server.

4 4

Important:

If tables that you are synchronizing 4include shadow columns, you must explicitly unload and load these columns. 4If these values are not included, Enterprise Replication inserts NULL values. For more information, 4see Shadow Column Disk Space and Loading 4and Unloading Data.