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