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:

   pdb_xlog move_truncpt

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

   pdb_xlog init, force

   Note:

   If you prefer to delete and replace all the information in the Replication Agent repository, issue the pdb_xlog remove, force command followed by a normal pdb_xlog 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)