Categories: Oracle GoldenGate


If you wanted to learn some basic concept of Oracle GOLDENGATE  this article “ORACLE GOLDEN GATE ARCHITECTURE” will help you out:

Oracle GoldenGate is a tool provided by oracle for transactional data replication among oracle databases and other RDBMS tools (SQL SERVER, DB2. Etc). Its modular architecture gives you the flexibility to easily decouple or combined to provide best solution to meet the business requirements.

Because of this flexibility in the architecture,GoldenGate supports numerous business requirements:
• High Availability
• Data Integration
• Zero downtime upgrade and migration
• Live reporting database

Oracle GoldenGate Architecture:


Oracle GoldenGate Architecture is composed of the following Components:
● Extract
● Data pump
● Replicat
● Trails or extract
● Checkpoints
● Manager
● Collector

Oracle Golden Gate server runs on both source and target server. Oracle GoldenGate is installed as an external component to the database and it wont uses database resource, in turn it won’t effect database performance. Where as Oracle streams which uses built in packages which are provided by oracle, which uses most of the database resources and there are chances of performance slow down in both source and target databases.

Let first have a look at architectural components of Oracle Golden Gate:

EXTRACT: Extract runs on the source system and it is the extraction mechanism for Oracle GoldenGate( capture the changes which happens at the source database).
The Extract process extracts the necessary data from the database transaction logs. For oracle database transaction logs are nothing both REDO log file data. Unlike streams which runs in the oracle database itself and needs the access to the database. Oracle GoldenGate does not needs access to the oracle database and also it will extract only the committed transaction from the online redo log file.
When ever there is a long running transaction which generates more number of redo data will force to switch the redo log file and in turn more number of archive logs will be generated. In these cases the extract process need to read the archive log files to get the data.
Extract process captures all the changes that are made to objects that are configured for synchronization. Multiple Extract processes can operate on different objects at the same time. For example once process could continuously extract transactional data changes and stream them to a decision support database, while another process performs batch extracts for periodic reporting or two extract processes could extract and transmit in parallel to two replicat processes ( with two trails) to minimize target latency when the databases are large.

DATAPUMP: Datapump is the secondary extract process with in source Oracle GoldenGate configuration. You can have the source Oracle GoldenGate configured without Datapump process also, but in this case Extract process has to send the data to trail file at the target. If the Datapump is configured the primary extract process writes the data to the source trail file and Datapump will read this trail file and propagate the data over the network to target trail file. The Datapump adds the storage flexibility and it isolates the primary extract process from TCP/IP activity.
You can configure the primary extract process and Datapump extract to extract online or extract during batch processing.

REPLICAT: Replicat process runs on the target system. Replicat reads extracted transactional data changes and DDL changes (IF CONFIGURED) that are specified in the Replicat configuration and than it replicates them to the target database.

TRAILS OR EXTRACTS: To support the continuous extraction and replication of source database changes, Oracle GoldenGate stores the captured changes temporarily on the disk in a series of files call a TRAIL. A trail can exist on the source or target system and even it can be in a intermediate system, depending on how the configuration is done. On the local system it is known as an EXTRACT TRAIL and on the remote system it is known as REMOTE TRAIL.
The use of a trail also allows extraction and replication activities to occur independently of each other. Since these two ( source trail and target trail) are independent you have more choices for how data is delivered.

CHECKPOINT: Checkpoints stores the current read and write positions of a process to disk for recovery purposes. These checkpoints ensure that data changes that are marked for synchronization are extracted by extract and replicated by replicat. Checkpoint work with inter process acknowledgments to prevent messages from being lost in the network. Oracle GoldenGate has a proprietary guaranteed-message delivery technology. Checkpoint information is maintained in checkpoint files within the dirchk sub-directory of the Oracle GoldenGate directory. Optionally, Replicat checkpoints can be maintained in a checkpoint table within the target database, apart from standard checkpoint file.

MANAGER: The Manager process runs on both source and target systems and it is the heart or control process of Oracle Golden Gate. Manager must be up and running before you create EXTRACT or REPLICAT process. Manager performs Monitoring, restarting oracle golden gate process, report errors, report events, maintains trail files and logs etc.

COLLECTOR: Collector is a process that runs in the background on the target system. Collector receives extracted database changes that are sent across the TCP/IP network and it writes them to a trail or extract file.

Fariddin Shaikh:

View Comments

  • Spot on with this write-up, I really assume this website needs far more consideration. I抣l in all probability be again to learn much more, thanks for that info.

  • Oh my goodness! an incredible article dude. Thanks Nonetheless I am experiencing difficulty with ur rss . Don抰 know why Unable to subscribe to it. Is there anyone getting equivalent rss problem? Anybody who is aware of kindly respond. Thnkx

  • Oh my goodness! an incredible article dude. Thanks Nonetheless I'm experiencing problem with ur rss . Don抰 know why Unable to subscribe to it. Is there anybody getting identical rss downside? Anybody who is aware of kindly respond. Thnkx

  • That is the right blog for anyone who needs to find out about this topic. You notice so much its nearly laborious to argue with you (not that I really would want匟aHa). You positively put a new spin on a subject thats been written about for years. Great stuff, just great!

  • You made some decent points there. I regarded on the web for the issue and found most individuals will go together with along with your website.

  • Thanks so much for providing individuals with an extraordinarily brilliant possiblity to check tips from this website. It is always so pleasurable and as well , stuffed with a great time for me personally and my office co-workers to visit your site at the very least three times a week to study the fresh things you will have. Of course, we are at all times impressed with your striking tips and hints served by you. Some 1 facts in this post are particularly the very best we have all ever had.

  • Spot on with this write-up, I actually suppose this website wants rather more consideration. I抣l most likely be once more to read far more, thanks for that info.