This post covers key points related to Oracle GoldenGate Architecture, Components, Installation and Review of Day1 of Oracle Golden Gate Training by Golden Gate Expert, Ashish.
Purpose of this post is to share lessons learned & key takeaway for me or DBAs & Oracle Apps DBAs who wish to learn GoldenGate.
If you are not sure if you are right fit for GoldenGate or What & Why to Learn Oracle GoldenGate or How to Learn Oracle GoldenGate like experts then check my Video Post on Blog here
Key Takeaway from Training: Module I
-
- Oracle GoldenGate can replicate data from any Oracle/Non-Oracle Database to any Oracle/Non-Oracle Database (or to even other data sources like JMS).
- Changes are tracked based on transaction logs in Source Database. In Oracle Database, these transactions logs are referred as Redo Logs & Archived Redo Logs
- Redo Log, Archived Redo Logs & Log Writer (LGWR) are an important component of Oracle Database Architecture from Oracle GoldenGate point of view and hence it is important that you learn Architecture of Oracle Database.Here is architecture diagram of Oracle Database and We cover this as first part in our Oracle GoldenGate Training
- Oracle Database Architecture consists A) Instance (memory & background processes) & B) Oracle Database (Data Files, Control File, Redo & Archive Redo Log Files). Redo & Archive Redo Log File in Oracle Database is the source of changes for GoldenGate
- There are few Data Replication Tools that are competitors to Oracle GoldenGate from IBM, Hitachi, Symantec Veritas, HP & Data core but GoldenGate is clearly among leaders because of Databases & Operating Systems it supports
- Architecture, Components & How GoldenGate works, is next Ashish covered in detail and this is what you must focus when learning Oracle GoldenGate or looking for Training on this topic. Pay special attention to Processes like Capture(Extract), Pump, Delivery(Replicat) and Trail Files (Local & Remote) storing committed Transactions. More on Oracle GoldenGate Components here
- In Oracle GoldenGate 12c, Oracle introduced Integrated Capture Process that works better than Classis Capture Process.
- Here is Module Summary i.e. What we covered in Module I of Oracle GoldenGate Training
Module II: Download & Install, Key Takeway
After Module I, We moved to Module II covering Download & Install of Oracle GoldenGate. Here are key things to note
- If source and target are different databases or of a different version, download the appropriate version of Oracle GoldenGate Software for respective Database.
- GoldenGate software for 12c Database is different than 11g Database so download correct GoldenGate version
- Manager Process manages other GoldenGate processes like Extract & Replicat
- For better understanding, install GoldenGate on Two Machines each running Database, one acting source and another as Target. Each trainee installed Oracle GoldenGate using our Step By Step Activity Guides
- Command Line Utility GGSCI (Golden Gate Server Command Line Interface) is used to Check & Manage Processes using command like ‘info all’ or ‘info all‘ or ‘info mgr‘
- The installation creates Directory Content folder like dirprm (Parameter File), dirdat (Data covering Trail Files), dirrpt, dirchk etc.
Pre-Requisite on Database
We then covered pre-requisites on Source & Target Database for Golden Gate Replication to work.
On Source Database:
- Set enable_goldengate_replication to TRUE.
- Create a Golden Gate user in Database (for 12c Create at Container Level with prefix C## ) that will be used to capture changes in database (extract information)
- Grant DBA role to user created in the previous step.
- Enable Supplemental Logging at Database Level. (Note: Supplemental Logging can be enabled at Database Level or Object Level.)
- The database should be in Archive Log Mode.
On Target Database:
- Set enable_goldengate_replication to TRUE.
- Create a Golden Gate user in Database (for 12c Create at Container Level with prefix C## ) that will be used to apply changes in the database.
- Grant DBA role to user created in the previous step.
That’s all for Day 1 GoldenGate Training, stay Tuned for my next post for the Day 2 of Oracle GoldenGate Training Workshop and if you want FREE 1 Hours Session on Oracle GoldenGate then Join Waitlist Here (We’ll Notify When We Re-Open FREE Webinar).
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.
Next Task For You
Want to move ahead in your career and want to get a higher Earning Job?
Get 7+ Courses for DBAs & Apps DBA in a bundle program and learn from the Industry’s best Experts.
Leave a Reply