In a test environment, you may occasionally need to reset the replication environment. Instead of deleting and re-creating a new Replication Agent instance, use this procedure to facilitate resetting the environment.
To reset the primary database for replication
Protect your new environment from old log information by using the following command in the Replication Agent to:
pdb_xlog move_truncpt
To retain marking and log device information, reinitialize the Replication Agent using pdb_xlog init with the force option, which forces the Replication Agent repository to be refreshed instead of overwritten:
pdb_xlog init, force
If you prefer to delete and replace all the information
in the Replication Agent repository, issue the pdb_xlog
remove command followed by a normal pdb_xlog
init command (without the force option).
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 NY, NYmss5 go
The following is displayed:
Locator has been reset to zero. (return status = 0)
