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

  1. 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"
    ...
    
  2. 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.