Reset the primary ASE database for replication

In a test environment, there may be times when the replication environment should be reset. Instead of deleting and re-creating a new Mirror Replication Agent instance, use this procedure to easily reset the environment.

1. Protect your new environment from old log information by using this command in the Mirror Replication Agent to move the transaction log truncation point to the end of the log:

   pdb_init move_truncpt
   

2. You can retain marking and log device information by re-initializing the Mirror Replication Agent using ra_init with the force option. This forces the Mirror Replication Agent repository to be refreshed instead of overwritten. Before and after invoking ra_init, you must quiesce and resume the primary database with the pdb_quiesce command:

   pdb_quiesce hold
   

   ra_init force
   

   pdb_quiesce release
   

   If you prefer to delete and replace all the information in the Mirror Replication Agent repository, issue the ra_deinit command followed by a normal ra_init command (without the force option):

   For more information about the ra_init command, see the Mirror Replication Agent Reference Manual.

3. Zero-out the locator stored in Replication Server using the rs_zeroltm command, for example:

   isql -USAMPLE_RS_RSSD_prim -PSAMPLE_RS_RSSD_prim_ps -SSAMPLE_RS_ERSSD -DSAMPLE_RS_ERSSD
   

   rs_zeroltm repit151i,foo
   

   go
   

   This message appears:

   Locator has been reset to zero.
   

   (return status = 0)