*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Or log in to access your purchased courses
by fatima
Price: 160,000
2 Months
0 Lessons

Oracle Goldengate 12c

Oracle Goldengate 12c

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

Course content: 

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

International Student Fee: 1000$


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

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us