Oracle GoldenGate

ORACLE

Oracle GoldenGate

Overview

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.

 

Oracle GoldenGate 11g  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

Using SQLEXEC to Interact Directly with a Database

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


Back to Top
Content