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:
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; |
Please create a dummy dbrsapply_plog_history table before executing above command for backup purpose. ( i.e :dbrsapply_plog_history_temp) |
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 |
How to determine what is X? To determine which Plog sequence to resend from, look at which Plog sequence the Apply process is currently at. Once Apply has processed a Plog, it is not possible to re-apply this Plog. So the earliest Plog that be resend is the Plog that is currently being applied. On the command console, if the Apply status is showing the following:
Then the plog sequence to resend is 11078. |