Oracle GoldenGate is a software that enables you to replicate, transform and filter data from one database to another, even across multiple heterogenous systems in your enterprise.
In part 1 of this blog, we discussed Oracle GoldenGate architecture and its primary components, i.e., Extract, Remote Trail and Data Pump. This blog covers the remaining important components you need to know to understand Oracle GoldenGate architecture completely.
The manager process is responsible for maintaining the rest of the processes in Oracle GoldenGate. It runs both on your source and the target site. This procedure is launched first by GoldenGate. The Manager then initiates and terminates each subsequent GoldenGate process, maintains the trail files, and also generates reports and log files.
Checkpoints are used for recovery purposes to store the current read and write positions of a process to disk.
Checkpoints ensure that data changes are marked for synchronization and are extracted by Extract and applied to the target. This leads to the prevention of redundant processing. Hence, they provide also prevent loss of data if the system, the network, or an Oracle GoldenGate process needs to be restarted.
Moreover, Checkpoints also help in complex synchronization configurations by facilitating multiple Extract/ Replicat processes to read from the same set of trails. They also ensure inter-process revelations and prevent message loss in the network.
Applying data updates to the target database is the procedure known as delivery. Delivery in GoldenGate is carried out utilising the native SQL database using a procedure known as the Replicat. Using different bind variables, Replicat executes a single SQL statement several times using dynamic SQL.
To preserve the reliability of the data, the Extract process wrote data changes to the trail file in the same order as they were committed on the source database, and the Replicat applies those changes in the same order. To boost throughput, you can run multiple Replicat processes simultaneously with one or more Extract processes and data pumps. Alternatively, you can configure one Replicat in an integrated mode rather than running multiple Replicat processes.
This is essentially all the Oracle GoldeGate theory you need to be aware of. In case you have any questions, let us know in the comments below. Want to know more about Oracle GoldenGate and best-in-class technology solutions? Get in touch with the experts at Princeton IT services.