Resynchronizing Data Among Replication Servers

Home | Previous Page | Next Page Setting Up and Managing Enterprise Replication > Managing Replication Servers and Replicates > 4 4 4

Resynchronizing Data Among Replication Servers

If replication 4has failed for some reason and data is not synchronized, there are different 4ways to correct data mismatches between replicated tables.

The following table compares each of the methods. All methods 4except manual table unloading and reloading can be performed while replication 4is active.

4 4444444444444444444444444444444

Table 18. Resynchronization methods
Method	Description
4Direct synchronization	4 44 44 Replicates all rows from the specified reference server to all specified 44target servers for a replicate or replicate set 44 Runs as a foreground process
4Checking consistency and then repairing inconsistent 44rows	4 44 44 Compares all rows from the specified target servers with the rows on the 44reference server, prepares a consistency report, and optionally repairs inconsistent 44rows 44 Runs as a foreground process 44 Requires preparation of checksum support functions
Repair job	4 4 Replicates all rows from the specified reference server to one target 4server for a replicate or replicate set 4 Two-step process: define a job and then start it 4 A job can only be used one time 4 Runs as a background process 4 Optionally filters a job so that only specific rows or columns are repaired
ATS or RIS file repairs	4 4 Used to repair rows that other synchronization methods could not repair. 4 Repairs a single transaction at a time. 4 Replicates or replication server must have been configured with the ATS 4or RIS option.
Manual table unloading and reloading	4 4 Manual process of unloading the target table, copying the reference table, 4and then loading the reference table into the target database 4 Requires that replication be suspended