Download PDF
of this course

Oracle GoldenGate 11g: Fundamentals for Oracle (G11GFO)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 4 Days

Price: SGD 3,360.00

The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course focuses on Oracle-to-Oracle database replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to use the Oracle GoldenGate command line interface (GGSCI) efficiently. Participants configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load. They learn to extract trails and files using Data Pump, create parameter files, and to manage Oracle GoldenGate instances. Capture of both DML and DDL will be configured for both uni- and bi-directional replication.

Learn To:

  • Install Oracle GoldenGate on Linux and Windows platforms
  • Issue GGSCI commands
  • Configure, start, stop, and monitor Change Capture and Delivery processes
  • Manage Extract trails and files using Data Pump and logdump
  • Create parameter files to transform data
  • Manage multiple Oracle GoldenGate instances

This course is based on Oracle Golden Gate version 11.2.1.


Who Should Attend

  • Database Administrators
  • Database Designers
  • System Integrator
  • Data Warehouse Analyst
  • Technical Consultant
  • Data Warehouse Developer
  • Configuration Consultant
  • Data Warehouse Administrator

Course Certifications

This course is part of the following Certifications:


Required Prerequisites:

  • Familiarity with Oracle Database and basic SQL using SQL*Plus.

Suggested Prerequisites:

  • Familiarity with Linux text editors such as vi or gedit

Course Objectives

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

Course Content

Oracle GoldenGate 11gR1 Introduction

  • Introducing Oracle GoldenGate Features and Functionality
  • Describing Oracle Middleware for Business Intelligence
  • Describing Oracle GoldenGate High Availability and Disaster Tolerance Solutions
  • Describing Oracle GoldenGate Real-time Data Integration Solutions

Understanding Oracle GoldenGate: Overview

  • Describing Oracle GoldenGate Functionality and Components
  • Listing Supported Databases and Platforms
  • Describing the Oracle GoldenGate Product Line

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 Number (CSN)
  • Describing Oracle GoldenGate Files

Installing Oracle GoldenGate

  • Installing Oracle GoldenGate on Linux
  • Preparing the Operating System
  • Running GoldenGate Commands from the GGSCI Prompt,
  • Using Obey Files and OS Shell
  • Get help information on GGSCI commands
  • Identify the types of GGSCI commands available

Configuration Overview and Preparing the Environment

  • Describing the High-level Configuration Steps
  • Configuring and Starting the Manager Process
  • Generating a Source Definitions File
  • Preparing a Source Database for Transaction Capture

Configuring Change Capture

  • Describing the Extract Process
  • Marking Tables with TRANDATA
  • Configuring Extract to Access Logs on Oracle ASM
  • Configuring and Starting an Extract Process
  • Addind Local and Remote Trails
  • Configuring and Starting an Extract Data Pump

Configuring Initial Load

  • Describing Oracle GoldenGate Initial Load Methods
  • Describing a Variety of Database-specific Methods
  • Explaining the Advantages of Oracle GoldenGate Methods
  • Configuring an Initial Load using Oracle GoldenGate

Configuring Change Delivery

  • Explaining the Replicat Process
  • Explaining Adding, Configuring and Starting a Replicat Process
  • Describing Avoid and Handle Collisions Between Changes and the Initial Load Data

Extracting Trails and Files

  • Describing and Contrast Extract Trails and Files
  • Investigating Different Formats
  • Viewing Extract Trails and Files with Logdump
  • Reversing the Sequence of Operations in an Extract Trail or File to Back out Changes

Working with Parameters

  • Editing Parameter Files
  • Contrasting GLOBALS with Process Parameters
  • Describing Commonly-used Parameters for GLOBALS, Manager, Extract and Replicat

Using Data Selection and Filtering

  • Selecting and Filtering Data for Replication
  • Mapping Columns Between Different Schemas
  • Using Built-in Functions
  • Useing SQLEXEC to Interact Directly with a Database

Using Additional Transformation Concepts

  • Creating and Invoking Macros
  • Setting and retrieving User Tokens
  • Running User Exits in GoldenGate Processes
  • Replicating Oracle Sequences

Introducing Configuration Options

  • Using BATCHSQL to Speed Delivery
  • Understanding Data Compress Across the Network
  • Enabling Message, Trail and Password Encryption
  • Using Event Records to Automatically Trigger Actions

Configuring Bidirectional Replication

  • Understanding Bidirectional Configuration
  • Detecting and Avoid Loops
  • Avoiding, Detecting, and Handling Conflicts
  • Handling Identity Types

Setting Up DDL Replication

  • Understanding the Concept of DDL Replication
  • Explaining the Requirements for Oracle DDL Replication
  • Describing GoldenGate Options for DDL Replication
  • Explaining DDL String Subsitution

Tuning and Troubleshooting

  • Controling Command Persionns
  • Managing Trail Files
  • Automating Process Setup
  • Restarting Oracle GoldenGate
  • Handling TCP/IP Errors
  • Using Reporting and Statistics
  • Monitoring Processes, Lags and Error Messages
  • Features of GoldenGate Management Pack

Course ID: G11GFO

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register