Resetting the Primary Oracle Database for Replication

In a test environment, you may occasionally need to reset the replication environment.

1. Archive all current redo log data:

   ra_locator move_truncpt

2. Reinitialize Replication Agent, which refreshes the Replication Agent repository rather than overwriting it:

   ra_admin refresh

   Note: If you prefer to delete and replace all the information in the Replication Agent repository, issue the ra_admin deinit, force command followed by a normal ra_admin init command (without the force option).
3. Reset the locator stored in Replication Server:
   

   isql -USAMPLE_RS_RSSD_prim -PSAMPLE_RS_RSSD_prim_ps
   -SSAMPLE_RS_ERSSD -DSAMPLE_RS_ERSSD
   rs_zeroltm NY, NYora92
   go

   You see:

   Locator has been reset to zero.
   (return status = 0)