What Does The HANDLECOLLISIONS Parameter Do? [ID 966207.1]

		修改时间 11-MAR-2011 类型 HOWTO 状态 PUBLISHED

In this Document
Solution

Applies to:

Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]
Information in this document applies to any platform.

Solution

Question
What does HANDLECOLLISIONS do?

Answer
HANDLECOLLISIONS is a Replicat parameter that is mainly used during initial loads. It lets you continue processing data in a trail even when there is a data integrity problem in the target environment, such as a missing row for an update, a missing row for a delete, or a duplicate insert.

When the HANDLECOLLISIONS parameter is set, data is processed as follows : -

Missing updates are ignored.
Missing deletes are ignored.
Duplicate inserts are turned into updates.

To enable this functionality, add the HANDLECOLLISIONS parameter to your Replicat parameter file. You can use it for a specific table or globally. After adding it, stop and start Replicat for it to take effect.

You can enable HANDLECOLLISIONS dynamically, without stopping Replicat by using the SEND command as follows:

GGSCI> SEND REPLICAT , HANDLECOLLISIONS []

To see whether HANDLECOLLISIONS is enabled, use the SEND command as follows:

SEND REPLICAT , REPORT HANDLECOLLISIONS []

It is NOT recommended to have HANDLECOLLISIONS active all of the time, because you may introduce data inconsistencies to the target. Processing will continue according the the rules stated previously, even if data is missing or duplicated. The main use of HANDLECOLLISIONS is when you start Replicat after an initial load during which source user applications remained online and GoldenGate captured their changes. HANDLECOLLISIONS resolves those ongoing changes with the changes made by the load. HANDLECOLLISIONS also can be used when you reposition Replicat backward in a trail to resolve other issues.

*NOTE : The default setting for replicat is NOHANDLECOLLISIONS

From GoldenGate version 8.0.2.1 and above, you will see a collision count for duplicate inserts in the Replicat statistics or report file when Replicat has been stopped.

显示相关信息 相关的

产品

Middleware > Data Integration > GoldenGate > Oracle GoldenGate

[@more@]

ITPub博客

What Does The HANDLECOLLISIONS Parameter Do? [ID 966207.1]

Applies to:

Solution

最新文章