Oracle GoldenGate 11g Fundamentals Training

Oracle Goldengate Training

The Oracle GoldenGate 11g Fundamentals for Oracle course focuses on Oracle-to-Oracle data 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 environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances.

Course Information

Oracle Golden Gate Course Duration: 40 Hours

Oracle Golden Gate Course Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Oracle Golden Gate Course Training Method: Online/Classroom Training

Oracle Golden Gate Course Training Study Material: Soft Copy

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

Key Features

Instructor Led Oracle Golden Gate Course Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request for demo