How do we resend a PLOG?
A PLOG can be resent from the MINE process to the APPLY process by using an internal engine command. Please see API and Internal Commands for more information.
The process is:
- Stop the MINE and APPLY processes
In the console type (use the PLOG sequence instead of X):
No Format dbvrep> ENGINE MINE RESET TO PLOG X
On the target or apply database, run:
No Format SQL> delete dbvrep.dbrsapply_plog_history where sequence>=X;
Note Please create a dummy dbrsapply_plog_history table before executing above command for backup purpose. ( i.e :dbrsapply_plog_history_temp)
- On the target or Apply server, move all the plogs >= sequence X that are in the "apply" directory to another location for backup purposes.
- On the source or Mine server, move all the plogs >= sequence X that are in the "mine" directory to another location for backup purposes.
- Restart MINE process
- Restart APPLY process
...