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.
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.