Oracle Golden Gate

Posted on Animesh KumarPosted in Uncategorized

GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the exchange and manipulation of data at the transactional level between a variety of database platforms like Oracle, DB2, SQL Server, Ingres, MySQL etc.
It can support a number of different business requirements like:
Business Continuity and High Availability
Data migrations and upgrades
Decision Support Systems and Data Warehousing
Data integration and consolidation

Let us know look at the different components and processes that make up a typical GoldenGate configuration on Oracle.

(source: Oracle GoldenGate Administration Guide and Gavin’s goldengate-concepts-and-architecture)
Manager
The Manager process must be running on both the source as well as target systems before the Extract or Replicat process can be started and performs a number of functions including monitoring and starting other GoldenGate processes, managing the trail files and also reporting purpose.
Extract
The Extract process runs on the source system and is the data capture mechanism of GoldenGate. It can be configured both for initial loading of the source data as well as to synchronize the changed data on the source with the target. Extract process is basically extracts data/ committed transactions from Redo Log.
Replicat
The Replicat process runs on the target system and reads transactional data changes as well as DDL changes and replicates then to the target database. Like the Extract process, the Replicat process can also be configured for Initial Load as well as Change Synchronization.
Collector
The Collector is a background process which runs on the target system and is started automatically by the Manager (Dynamic Collector) or it can be configured to start manually (Static Collector). It receives extracted data changes that are sent via TCP/IP and writes then to the trail files from where they are processed by the Replicat process.
Trails
Trails are series of files that GoldenGate temporarily stores on disks and these files are written to and read from by the Extract and Replicat processes as the case may be. Depending on the configuration chosen, these trail files can exist on the source as well as on the target systems. If it exists on the local system, it will be known an Extract Trail or as an Remote Trail if it exists on the target system.
Data Pumps
Data Pumps are secondary extract mechanisms which exist in the source configuration. This is optional component and if Data Pump is not used then Extract sends data via TCP/IP to the remote trail on the target. When Data Pump is configured, the the Primary Extract process will write to the Local Trail and then this trail is read by the Data Pump and data is sent over the network to Remote Trails on the target system.
In the absence of Data Pump, the data that the Extract process extracts resides in memory alone and there is no storage of this data anywhere on the source system. In case of network of target failures, there could be cases where the primary extract process can abort or abend. Data Pump can also be useful in those cases where we are doing complex filtering and transformation of data as well as when we are consolidating data from many sources to a central target.
Data source
When processing transnational data changes, the Extract process can obtain data directly from the database transaction logs (Oracle, MySQL, DB2, SQL Server etc) or from a GoldenGate Vendor Access Module (VAM) where the database vendor (for example Teradata) will provide the required components that will be used by Extract to extract the data changes.
Groups
To differentiate between the number of different Extract and Replicat groups which can potentially co-exist on a system, we can define processing groups. For instance, if we want to replicate different sets of data in parallel, we can create two Replicat groups.
A processing group consists of a process which could be either a Extract or Replicat process, a corresponding parameter file, checkpoint file or checkpoint table (for Replicat) and other files which could be associated with the process.

153 thoughts on “Oracle Golden Gate”

  21. Nicely put. Regards.
    [url=https://essaypromaster.com/]paper writers for hire[/url] do my papers [url=https://paperwritingservicecheap.com/]write my papers[/url] how to write an abstract for a research paper

    Reply

  26. Fantastic postings. Appreciate it.
    [url=https://dissertationwritingtops.com/]dissertation editing help[/url] phd dissertation [url=https://helpwritingdissertation.com/]dissertation writing tips[/url] cheap dissertation writing

    Reply

  27. Really quite a lot of very good data!
    [url=https://hireawriterforanessay.com/]essay help writer[/url] essay writer bot [url=https://theessayswriters.com/]essay writer free online[/url] what should i do my persuasive essay on

    Reply

  29. Truly loads of useful facts.
    [url=https://homeworkcourseworkhelps.com/]online coursework[/url] do my math homework for me [url=https://helpmedomyxyzhomework.com/]homework help[/url] do my programming homework

    Reply

  31. You definitely made the point!
    [url=https://payforanessaysonline.com/]buy essay online[/url] pay someone to write my college essay [url=https://buycheapessaysonline.com/]pay someone to write paper[/url] buy essays cheap

    Reply

  38. Thanks a lot! Numerous facts!
    [url=https://dissertationwritingtops.com/]dissertation editing services[/url] phd weight loss [url=https://helpwritingdissertation.com/]dissertation writers[/url] writing dissertations

    Reply

  40. You actually suggested it effectively!
    [url=https://hireawriterforanessay.com/]write my paper for me free[/url] do my essay [url=https://theessayswriters.com/]online essay writers[/url] write my essay

    Reply

  50. Nicely put, Appreciate it!
    [url=https://essaypromaster.com/]how to write a philosophy paper[/url] how to write a paper [url=https://paperwritingservicecheap.com/]how to write a reflective paper[/url] paper writing service

    Reply

  58. I am an investor of gate io, I have consulted a lot of information, I hope to upgrade my investment strategy with a new model. Your article creation ideas have given me a lot of inspiration, but I still have some doubts. I wonder if you can help me? Thanks.

    Reply

  59. I am an investor of gate io, I have consulted a lot of information, I hope to upgrade my investment strategy with a new model. Your article creation ideas have given me a lot of inspiration, but I still have some doubts. I wonder if you can help me? Thanks.

    Reply

  60. Wonderful forum posts, Kudos!
    [url=https://essaywritingservicelinked.com/]writing essay[/url] good essay writing service [url=https://essaywritingservicetop.com/]essay writing site[/url] cheapest essay writing service uk

    Reply

  69. Thanks a lot! An abundance of advice.
    [url=https://writinganessaycollegeservice.com/]essay writing service uk[/url] essay writing companies [url=https://essayservicehelp.com/]best research paper writing service[/url] cheap assignment writing service

    Reply

  70. At the beginning, I was still puzzled. Since I read your article, I have been very impressed. It has provided a lot of innovative ideas for my thesis related to gate.io. Thank u. But I still have some doubts, can you help me? Thanks.

    Reply

  71. Amazing postings. Cheers!
    [url=https://essaytyperhelp.com/]help writing essay[/url] helping others essay [url=https://helptowriteanessay.com/]help writing essay[/url] free writing assistant

    Reply

  73. At the beginning, I was still puzzled. Since I read your article, I have been very impressed. It has provided a lot of innovative ideas for my thesis related to gate.io. Thank u. But I still have some doubts, can you help me? Thanks.

    Reply

  80. You mentioned this effectively!
    [url=https://essaywritingservicelinked.com/]grad school essay writing service[/url] are essay writing services safe [url=https://essaywritingservicetop.com/]essay writting service[/url] paper writing service college

    Reply

  82. You said it adequately.!
    [url=https://service-essay.com/]buying papers for college[/url] pay for college papers [url=https://custompaperwritingservices.com/]best college paper writing service[/url] pay for paper

    Reply

  88. Incredible loads of useful tips!
    [url=https://payforanessaysonline.com/]buy essays[/url] pay to write paper [url=https://buycheapessaysonline.com/]pay for essay[/url] where to buy essays online

    Reply

  92. Thanks a lot! A lot of content!
    [url=https://quality-essays.com/]pay to write essay[/url] buy college essays [url=https://buyanessayscheaponline.com/]buy essay papers[/url] pay to write essay

    Reply

  99. Superb stuff. Appreciate it.
    [url=https://topswritingservices.com/]college admissions essay writing service[/url] assignment writing service [url=https://essaywriting4you.com/]essay writing service coupon[/url] urgent essay writing service

    Reply

  102. Regards, Plenty of stuff!
    [url=https://quality-essays.com/]pay to write paper[/url] where to buy essays online [url=https://buyanessayscheaponline.com/]buy essays[/url] buy essays online

    Reply

  105. Very well expressed really! .
    [url=https://hireawriterforanessay.com/]ai essay writer[/url] essay writer no plagiarism [url=https://theessayswriters.com/]write my paper for me free[/url] write my thesis for me

    Reply

  115. أكبر شركة لانتاج أنابيب البولي ايثيلين و يو بي سي ومستلزماتها للمنتجات الصناعية في عيراق

    Reply

Leave a Reply

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

18 ÷ 9 =