Resynchronizing both the primary and replicate databases from the same dump

Use this procedure to coordinate resynchronization to reload both the primary database and replicate database from the same dump or copy of data. No dump database marker is needed, since you are not obtaining a dump from the primary database.

1. Stop replication processing by Replication Agent. Do not alter the truncation point. In Replication Agent, execute:

   suspend
   

2. Suspend the Replication Server DSI connection to the replicate database:

   suspend connection to data_server.database
   

3. Instruct Replication Server to remove data from the replicate database outbound queue and wait for a resync marker from the primary database Replication Agent:

   resume connection to data_server.database skip to 
   resync marker
   

4. Apply the dump of the data from the external source to the primary database.

5. Move the truncation point to the end of the transaction log for the primary database. In Replication Agent, execute:

   pdb_xlog move_truncpt
   go
   

6. Reinitialize Replication Agent repository based on the latest system data from the primary database:

   ra_init force
   go
   

7. Instruct Replication Agent to start in resync mode with the init option. In Replication Agent, execute:.

   resume resync, init
   

8. Verify that DSI has received and accepted the resync marker from the Replication Agent by looking for this message in the Replication Server system log:

   DSI for data_server.database received and processed
   Resync Database Marker. DSI is now suspended. Resume 
   after database has been reloaded.
   
   

   When Replication Server receives and processes the resync database with init marker, the DSI connection suspends.

9. Apply the dump of the data from the external source to the replicate database.

10. After you apply the dump to the replicate database, resume DSI to the replicate database to allow Replication Server to apply transactions from the primary database:

    resume connection to data_server.database