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.
Resetting the primary database for replication
Protect your new environment from old log information by using the following command in the Replication Agent to archive all current redo log data:
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).
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, NYmss5
go
The following appears:
Locator has been reset to zero.
(return status = 0)
