Monthly Archive: December 2015

ORACLE GOLDENGATE CHECKPOINTS

Each and every processes in Oracle GoldenGate has it’s own checkpoints to maintain data integrity.

This article explains the different types of checkpoints and the uses of it.

As we know there are multiple processes involved in Oracle GoldenGate replication, the below are the processes which maintains the checkpoint information for each and every operations it does.,

1. Extract or Capture Process
2. Secondary Extract or DataPump Process
3. Replicat Process

EXTRACT PROCESS

This process captures the committed changes from the Redo Log or Archive Log files and writes them to the Trail files called Local Trails. The Extract Process
not only captures the committed changes but also keeps track of all the Open transactions so that it ensures that it does not misses any data or no data loss.
Continue reading…

ORACLE GOLDENGATE INSERTALLRECORDS – To Maintain Transaction History

This parameter is used at the Replicat Side. When using this parameter, it causes Replicat process to insert each and every change that has been made to a record as a new record in the database. So whatever operations are performed in the source table (Insert or Delete or Update), everything will be converted in to the insert statement and will be inserted to the target table. The initial insert and subsequent updates and deletes are maintained as point-in-time snapshots.

There are two major reasons for using the parameter INSERTALLRECORDS,

1. When exception MAP statement is used in the target. The operations which causes error will be inserted in the Exception table. This is called as Error Handling.
Continue reading…

How to start the Oracle GoldenGate Collector Process Manually?

Oracle GoldenGate Server Collector process plays a vital role in the Oracle GoldenGate Replication. But we could not see this process in the INFO ALL command output. Because this process is started internally by the manager process automatically. But we all know that, we can also start the Collector process manually. But How to start it? Searched in google for the document but couldn’t find one. So thought of creating this article.

SERVER COLLECTOR PROCESS

There are two Extract Processes. Primary Extract and Secondary Extract (called DataPump / Extract Pump).The Extract Pump is the process at the Source side which communicates with the Target Manager process and requests manager to open the port for the Server Collector process at the Target Side.
So the Server Collector process will be invoked by the Target Manager process. The Collector process in turn receives the changes from the Extract Pump process and writes the changes to the Remote Trail files.

Continue reading…