Resynchronizing Replicate Databases

Obtain a datra dump from a trusted source and apply the dump to the target database you want to resynchronize.

  1. Stop replication processing by suspending Replication Agent.
  2. Place Replication Server in resync mode.
    In resync mode, Replication Server skips transactions and purges replication data from replication queues in anticipation of the replicate database being repopulated from a dump taken from the primary database or trusted source.
  3. Restart Replication Agent and send a resync database marker to Replication Server to indicate that a resynchronization effort is in progress.
  4. Obtain a dump from the primary database.
    When Replication Server detects a dump marker that indicates completion of the primary database dump, Replication Server stops skipping transactions and can determine which transactions to apply to the replicate database.
  5. Apply the dump to the replicate database.
  6. Resume replication.