Oracle Goldengate Architecture

Hi,

 

I will tell Oracle Goldengate architecture in this post.

 

If you don’t  know how to install and configure Oracle Goldengate, read the following article.

https://ittutorial.org/oracle-goldengate-12c-installation-and-configuration-3/

 

 

We can replicate the records of the transactions made on the source database to the target databases with Oracle GoldenGate, we can replicate in real time or on a delayed basis. This replication may involve all database operations performed in the source database, but can also be performed as a replication of only one seqeunce, table or schema.

One of the key features of Oracle GoldenGate is its hybrid structure. As the source database can be Oracle, the target database can be MS-SQL Server or vice versa. Thanks to its Oracle GoldenGate hybrid structure, it can support replication in cross-platform or database. Examples include; Oracle, MS-SQL, Postgre SQL, MySQL and IBM DB2.

Oracle GoldenGate is installed separately to the source and target servers, and the configurations of the servers can be different. While the processes on the source server are called Extract and Pumper , the processes on the target server are called Collector and Replicat . In addition to these, both sides have the Manager process. You can see this process architecture like following picture.

 

 

Goldengate Architecture

 

 

 

Now let us explain briefly these terms.

 

 

Manager: As the name implies, this process is main process and the management process of Oracle GoldenGate. Works on both source and destination servers. The configuration of GoldenGate is managed via this process. Sample; The trail files produced by the Extract process and reporting are under the management of this processes . In order for Extract, Pumper and Replicat processes to work, the Manager must be run. The length of time the trail files produced by the Extract process are stored is checked through the Manager process.

Extract: This process is running on the source database is responsible for capturing the records of all transactions performed in the database. These records are collected primarily from the Online Redolog (removed from RBA numbers) files or from archive files.

 

 

 

 

Pumper: The task of this process is to send the trail files generated by the Extract process to the target server via the defined 7809 port (TCP / IP) on the Manager service.

Replicat: Replicat process , as the name suggests, is responsible for processing the trail files sent by the Pumper process running on the source server to the target database. You can run incoming trail files in real time (online) or you can operate them in a delayed manner by means of parameters.

Collector: The Collector process is a background service of GoldenGate and only works on the target server. This process is responsible for processing the posted trail files and bringing them into the format that the Replicat process can use.

 

 

 

 

 

 

 

Do you want to learn Oracle Goldengate, then read the following articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

11 comments

  1. If you desire to increase your know-how simply keep visiting this web page and be updated with the most recent news posted here.|

  2. I’ve observed that in the world of today, video games include the latest trend with kids of all ages. Occasionally it may be not possible to drag young kids away from the activities. If you want the very best of both worlds, there are numerous educational gaming activities for kids. Good post.

  3. Normally I don’t learn post on blogs, however I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thank you, quite nice article.|

  4. If some one desires expert view about blogging after that i recommend him/her to visit this weblog, Keep up the fastidious work.|

  5. Hi, i believe that i noticed you visited my website thus i came to return the favor?.I am attempting to in finding issues to improve my web site!I assume its adequate to use some of your ideas!!|

  6. This site was… how do I say it? Relevant!! Finally I have found something which helped me. Kudos!|

  7. I’d like to thank you for the efforts you’ve put in penning this website. I really hope to view the same high-grade content by you later on as well. In truth, your creative writing abilities has inspired me to get my own blog now ;)|

  8. Hello! Do you use Twitter? I’d like to follow you if that would be okay. I’m definitely enjoying your blog and look forward to new posts.|

Leave a Reply

Your email address will not be published. Required fields are marked *