Method 4: lshistory and recoverpacket method
To recover a lost packet, you can use the lshistory command to determine the time of the last successful import and then use a recoverpacket command to recover all packets since that time.
About this task
Procedure
- At the replica that failed to apply the lost packet, use the lshistory command
to determine the time of the last successful import of an update packet from
the replica that sent the lost packet.
GOLDENGATE> cleartool lshistory replica:sanfran_hub 01-Aug.07:08 jcole import sync from replica "boston_hub" to replica "sanfran_hub" “Imported synchronization information from replica "boston_hub". Row at import was: sanfran_hub=2000 boston_hub=1300 bangalore=950" ...
- At the sending replica, use this time in a recoverpacket command.
The recoverpacket command looks through epoch rows
to find an event that occurred prior to the specified time. When it finds
a matching row, it resets the epoch row for the receiving replica.
susan@minuteman% multitool recoverpacket –since 01-Aug.01:00 sanfran_hub
Results
Note: With this method, you must adjust the time from the lshistory output
for time zone differences and the amount of time elapsed between export and
import.