The RESTARTCOLLISION parameter is used to skip ONE transaction only in a situation when the GoldenGate PROCESS crashed and performed an OPERATION (INSERT, UPDATE & DELETE) in the database but COULD not checkpoint the process information to the checkpoint file/table. On RECOVERY it will skip the transaction and AUTOMATICALLY continue to the next operation in the trail file.

When using HANDLECOLLISION GoldenGate will continue to overwritten and process transactions until the parameter is removed from the parameter files and the PROCESSES restarted.

The RESTARTCOLLISION parameter is used to skip ONE transaction only in a situation when the GoldenGate process crashed and performed an operation (INSERT, UPDATE & DELETE) in the database but could not checkpoint the process information to the checkpoint file/table. On recovery it will skip the transaction and AUTOMATICALLY continue to the next operation in the trail file.

When using HANDLECOLLISION GoldenGate will continue to overwritten and process transactions until the parameter is removed from the parameter files and the processes restarted.