Oracle GoldenGate 12c Training : Step by Step Activity Guides /Hands-On Lab Exercise

Oracle

Share Post Now :

HOW TO GET HIGH PAYING JOBS IN AWS CLOUD

Even as a beginner with NO Experience Coding Language

Explore Free course Now

Table of Contents

Loading

This post covers Sneak Peek of Step by Step Hands-On Guides from our Oracle GoldenGate 12c Training where you get to learn things like Architecture, Installation, Configuring & Preparing the environment, DML replication, Initial Load, Zero downtime migration and Upgrading using GoldenGate, Parameter files, DDL Replication, Bi-directional Replication, Oracle GoldenGate Security and much more.

Here’s the Quick Sneak Peek of What You will do on your Dedicated Machine for Oracle GoldenGate Training:

1. Lab Activity Guide I: Oracle GoldenGate 12c Installation & Configuring & Preparing New Environment

We start with Overview of Oracle Database architecture and discussion related to transaction logs of Database which acts as a source for Oracle GoldenGate – Redo logs and Archive logs. In this lab activity guide, we learn about how to download install Oracle GoldenGate. We’ll explain File System of Oracle GoldenGate Installation.We then learn to configure database and preparing the environment for GoldenGate Replication, Start/Stop Database, and Access Database EM.

Installation

2. Lab Activity Guide II: Configure GG & DML Replication

In this module, we discuss configuring Extract, Data Pump, and Replicat processes and understand how to process data flow from source to target.

DML Replication

DML

3. Lab Activity Guide III: IgnoreUpdates & IgnoreDeletes & Parameters & HandleCollisions

In this module, we discuss what are parameters of Oracle GoldenGate and how to comprehend or Configure existing parameter file .

Handle Collison

4. Lab Activity Guide IV: Initial Load

In this module, we discuss how to perform Initial Load using GoldenGate and how it is different from database utilities like RMAN, Export-import, and transportable tablespace.

Initial Load

5. Lab Activity Guide V: Data Filtration using WHERE & FILTER CLAUSE 12c

Here we discuss Data Filtration using WHERE & FILTER CLAUSE 12c in Oracle Goldengate.

Data Filtration

6. Lab Activity Guide VI: Data Transformation & Data Manipulation using COLMAP CLAUSE 12c

Here we discuss Data Transformation & Data Manipulation using COLMAP CLAUSE 12c in Oracle Goldengate.

Data Transformation

7. Lab Activity Guide VII: DDL Replication

In this module, we discuss how to enable DDL Replication.

DDL Replication

8. Lab Activity Guide VIII: Bi-Directional Replication

In this module, we discuss how to setup bi-directional Replication and issues related to it.

Bidirectional Replication

9. Lab Activity Guide IX: Oracle GoldenGate Security

In this module, we discuss configuring security features in our Oracle GoldenGate Environment for safeguarding our data and user credentials.

Security

10. Lab Activity Guide X: Troubleshooting Oracle GoldenGate Issues

In this module, we will discuss how to troubleshoot any issue in GoldenGate along with altering the GoldenGate processes based on SCN/DB logs and timestamp

Troubleshooting Issues

11. Lab Activity Guide XI: LogDump

In this module, we will discuss how to read the trail files using logdump utility
Log Dump

12. Lab Activity Guide XII: Data Definition File

In this module, we will discuss Data Definition File.

Data Definition File
By following these Hands-on guides on the dedicated machine, one can easily learn Oracle Goldengate 12c. Don’t believe our words, here is the feedback from two of our trainees.
Believe me and 1000s of our Trainees who have gone through Oracle trainings, if you practice these guides (You get a Dedicated Machine on Cloud to Practice) then you will learn and become proficient in Oracle GoldenGate

Here are some of the reasons why our students think we are the best Oracle Training Institute

  1. Live Instructor-led Online Sessions
  2. Unlimited FREE retake for next 3 Years
  3. Training Material with Hands-on Lab Exercises (11+ Activity guides)
  4. Recording of Live Interactive Session for lifetime Access
  5. Dedicated Machines to Practice
  6. Email & WhatsApp Support
  7. Help in CV Preparation
  8. 100% Money Back Guarantee (If you attend sessions, practice and don’t get results, We’ll do full REFUND, check our refund policy)

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.

Oracle Bundle Training

Picture of mike

mike

I started my IT career in 2000 as an Oracle DBA/Apps DBA. The first few years were tough (<$100/month), with very little growth. In 2004, I moved to the UK. After working really hard, I landed a job that paid me £2700 per month. In February 2005, I saw a job that was £450 per day, which was nearly 4 times of my then salary.