Chapter 05 : Capture and Apply Modes

 Choosing Capture and Apply Modes

For an Oracle database, you can run extract group in either Classic Capture and Integrated Capture Mode.

Capture Modes

Capture or Extract Process can be of two types: Classic Extract and Integrated Extract.

Classic Capture / Extract

• In a Classic capture mode, the Oracle Goldengate Extract process captures data changes from the Oracle redo or archive log files on the source system or from shipped archived log on a standby system

.

Integrated Capture / Extract

• In Integrated Capture mode, the Oracle Goldengate Extract process interacts directly with a database logmining server to receive data changes in the form of Logical Change Record (LCR).

Apply Modes

Apply or Replicat Process can be of 2 types: Nonintegrated (Classic) Replicat, Integrated Replicat

Non-integrated Replicat

• In non-integrated mode, the Replicat process uses standard SQL apply data changes directly to the target tables.

Integrated Replicat

• In Integrated mode, the Replicat process leverages the apply processing functionality that is available within the Oracle database with the help of a database inbound server by means of a lightweight streaming API .