Module 1: GoldenGate Architecture, Component & Concepts

Lesson 1 – Oracle Database Architecture

Lesson 2 – Competitors, Why GoldenGate and Options

Lesson 3 – GoldenGate Architecture Supported Database OS

Lesson 4 – Integrated Capture

Module 2: Pre-Requisite, Download & Install GoldenGate

Lesson 1 – Oracle GoldenGate Download Install

Lesson 2 – GoldenGate Directory Structure & GGSCI Manager Process

Lesson 3 – Oracle GoldenGate Target Install Configure Manage

Lesson 4 – Load Data Source Target Database

Lesson 5 – Configure Source Target Pre Requisite

 Module 3: Process,Configuration & DML Setup

Lesson 1 – GoldenGate Source & Target Database Installation Review

Lesson 2 – GGSCI Database Login & Enable Supplemental Logging

Lesson 3 – Check and Delete Supplemental Logging Information

Lesson 4 – Configure, Capture Process and Register with Database

Lesson 5 – Define Local Trail, Data Pump & Remote Trail

Lesson 6 – Parameter Files and How to Edit File

Lesson 7 – Starting Extract Processes and View Report

Lesson 8 – Configure and Start Replicat Process on Target

Lesson 9 – Test Replication from Source to Target, Flow and Statistics

Lesson 10 – Capture & Replicat process is on the Same Host, What Could be Going on Here?

Module 4: Parameter, Topologies, Components, Collisions

Lesson 1 – Recap Processes and Report File

Lesson 2 – GoldenGate Topologies

Lesson 3 – GoldenGate Components: Extract, Manager, Replicat, Collector, DataPump & Trail Files

Lesson 4 – GoldenGate Parameter Files

Lesson 5 – Parameter Description & Other Parameters

Lesson 6 – Collision Handling

Lesson 7 – Troubleshooting of Insert collision in GoldenGate

Lesson 8 – How to Handle Update Collision

Lesson 9 – InsertMissing Collision and Delete Collision

Module 5: Initial Load & Zero Downtime Migration and Upgradation

Lesson 1 – Process, Global and OBEY Parameter File

Lesson 2 – INITIAL load in GoldenGate

Lesson 3 – Why Zero Downtime Upgradation and Migration is Important

Lesson 4 – Advantages of Initial Load

Lesson 5 – Zero DownTime Upgradtion and Migration

Module 6: Data Transformation using COLMAP & Performance of GoldenGate

Lesson 1 – Data Transformation using COLMAP with Hands-on Exercise

Lesson 2 – How to Alter Processes In Oracle GoldenGate

Lesson 3 – How to Replicate Colum having Different Colum Name

Lesson 4 – Hands-on with Oracle GoldenGate Built-in Functions

Lesson 5 – Q/A Session

Lesson 6 – Capabilities and Syntax of GoldenGate

Lesson 7 – Performance Overview of Oracle GoldenGate

Lesson 8 – Monitoring the LAG in GoldenGate

Lesson 9 – GoldenGate Checkpoints

Who this course is for:

• DBA’s
• Developers
• Solution Architects
• Database Administrators
• Data Architects
• Data Replication
• Disaster Recovery

Oracle Job Interview Preparation

• Oracle DBA Interview Question and Answer
• Oracle Fusion Cloud Technical Interview Question
• Oracle Fusion Cloud Techno Functional Interview Question
• Oracle Fusion Financials Cloud Interview Questions

International Student Fee: 1000$