Oracle Goldengate Architecture

Hi,

 

I will tell Oracle Goldengate architecture in this post.

 

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.

 

 

 

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.

 

 

 

 

 

 

 

Mehmet Salih Deveci

I am Founder of 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 mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

11 thoughts on “Oracle Goldengate Architecture

  • May 12, 2019 at 4:13 am
    Permalink

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

    Reply
  • May 16, 2019 at 12:02 pm
    Permalink

    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.

    Reply
  • May 21, 2019 at 8:11 am
    Permalink

    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.|

    Reply
  • May 21, 2019 at 8:13 am
    Permalink

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

    Reply
  • May 21, 2019 at 8:13 am
    Permalink

    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!!|

    Reply
  • May 21, 2019 at 8:13 am
    Permalink

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

    Reply
  • May 21, 2019 at 8:13 am
    Permalink

    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 ;)|

    Reply
  • May 21, 2019 at 8:14 am
    Permalink

    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.|

    Reply

Leave a Reply

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