Oracle GoldenGate 12c: Fundamentals for Oracle

Oracle GoldenGate 12c: Fundamentals for Oracle Certification Training Course Overview

Enroll for the 4-days Oracle GoldenGate 12c: Fundamentals for Oracle course from Koenig Solutions accredited by Oracle. This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.

Target Audience:

  • Administrator
  • Analyst
  • Architect
  • Database Administrator
  • Developer
  • Implementer
  • System Integrator

 

Oracle GoldenGate 12c: Fundamentals for Oracle (32 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training
02 - 05 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 09 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Technology Overview
  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
Module 2: Oracle GoldenGate Architecture
  • Describing Oracle GoldenGate Process Groups
  • Explaining Change Capture and Delivery (with and without a Data Pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
Module 3: Installing Oracle GoldenGate
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
Module 4: Configuration Overview and Preparing the Environment
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package
Module 5: Configuring Change Capture (Extract)
  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
Module 6: Configuring Change Delivery (Replicat)
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat
Module 7: Configuring Extract Trails and Files (Data Pump)
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
Module 8: Performing Initial Load
  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Configuring Direct Load Methods
  • Handling Collisions with Initial Load
Module 9: Performing Initial Load
  • Filtering and Data Selection
  • Additional Transformation Concepts
Module 10: Configuration Options
  • Bidirectional Replication
  • DDL Replication
Download Course Contents

Request More Information

Course Prerequisites

Course objectives:

  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate and prepare the source and target database (assumes Oracle-to-Oracle replication)
  • Issue GGSCI commands (batch Obey scripts and command-line interactive)
  • Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load
  • Manage Extract trails and files using Data Pump and utilities such as logdump
  • Control network transmission using compression and encryption
  • Transform data