2.114 GETROLLBACKS | IGNOREROLLBACKS

Valid for

Extract

Description

Use GETROLLBACKS or IGNOREROLLBACKS to include or exclude records created by TMF rollback processes.

Use GETROLLBACKS only when performing change synchronization while extracting initial-load data. If you perform initial load while the source database remains up, GETROLLBACKS guarantees that aborted transactions occurring during the initial extraction phase are rolled back on the target database. This is because initial extraction uses browse access against the source table, which can result in retrieval of records that are later rolled back.

After initial load is complete, issue the SEND EXTRACT group_name IGNOREROLLBACKS command from GGSCI.

GETROLLBACKS is only required when the initial-load method uses a bulk method, such as BACKUP, to extract the data or when using Oracle GoldenGate with the FASTUNLOADSHARED parameter.

Default

IGNOREROLLBACKS

Syntax

GETROLLBACKS | IGNOREROLLBACKS