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):
dbvrep> ENGINE MINE RESET TO PLOG X
On the target or apply database, run:
SQL> delete dbvrep.dbrsapply_plog_history where sequence>=X;
- On the target or Apply server, move all the plogs that are in the "apply" directory to another location for backup purposes.
- Restart MINE process
- Restart APPLY process
The following message in the log file may indicate that a PLOG needs to be resent if this message does not progress:
WARN-2403: Incomplete PLOG X, but not an online log. Rerequesting it from mine, sleeping and trying again