This post covers what is Oracle GoldenGate, how it works, who should learn it and 10 point checklist to learn Oracle GoldenGate like experts.
In this short video, we are going to look:
- What is GoldenGate?
- How GoldenGate Works
- Who should learn GoldenGate?
- 10 point checklist to learn GoldenGate?
What is GoldenGate?
Oracle GoldenGate (OGG) provides near real-time transactional data replication. Replication may be uni-directional, bi-directional or multi-dimensional. Replication can involve several sources and targets simultaneously and be used for distributing data for backup, hot standby, auditing, reporting, warehousing and load distribution (etc). Data may be replicated as is, or the replicated data may be edited, transformed, split into different distributions, have meta data added, or filtered. Both DMLs and DDLs may be replicated in whole or in part.
To understand how GoldenGate works you should first know about Components of Oracle GoldenGate
How GoldenGate Works?
The advantage of GoldenGate is that it can replicate the data between heterogeneous databases and it can work on heterogeneous platforms as well. The source data could be Oracle or Non- Oracle.
GlodenGate Replication Flow
The typical GoldenGate flow shows new and changed database data being captured from the source database. The captured data is written to a file called the source trail. The trail is then read by a data pump, sent across the network, and written to a remote trail file by the Collector process. The delivery function reads the remote trail and updates the target database. Each of the components is managed by the Manager process.
Who should learn GoldenGate?
If you are a DBAs (Oracle and Non-Oracle Database Administrators), PL/SQL Developers, Technologists responsible for Data Replication, High Availability Data Technologists
For practice, we also cover step by step activity guide dedicated on our Cloud Machine.
10 point checklist to learn GoldenGate
- Architecture of Oracle GoldenGate
- Install of Oracle GoldenGate 12c
- Configure & Prepare Environment
- Online Change Synchronization
- Parameter Files
- Security in GoldenGate
- Troubleshoot GoldenGate Issues
- Managing Oracle GoldenGate
- Read trail files using Logdump
- Performance of GoldenGate
This post is from our Oracle GoldenGate 12c Administration Training, in which we cover Architecture, Installation, Configuring & Preparing the Environment, DML Replication – Online Change Synchronization, Initial Load, Zero Downtime Migration & Upgrading using GoldenGate, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.
If you are looking for commonly asked interview questions for Oracle GoldenGate then just click below and get that in your inbox or join our Private Facebook Group dedicated to Oracle GoldenGate Members Only.
Do you have any queries in Oracle GoldenGate 12c?
Have a question related to your Oracle GoldenGate Career?