Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.
What you’ll learn:
-
Installaton of Oracle Goldengate
-
Architecture of Oracle Goldengate – Process Data Flow
-
Implementation and Configuration of Goldengate processes – Integrated and Classic modes
-
Configure unidirectional and bidirectional setup
-
Goldengate on RAC – Strategy and Installation
-
Logdump utility
-
Zero Downtime migration and upgradation using Oracle Goldengate
-
DDL Replication
-
Troubleshooting strategy
-
Understanding and Configuration of Parameter files
-
HANDLECOLLISIONS
-
Data Filteration and Transformation
-
Goldengate Macros
-
Include File in Goldengate
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$
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
🎥 Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Popular Courses
Oracle GoldenGate 11g Certified Implementation
Oracle Database Administration – OCP/OCA
ORACLE DATA GUARD ADMINISTRATION
Oracle Database 12C Data Guard Administration Course
Oracle Database 11g – Data Guard Administration
KEY FEATURES
Register Now
