Oracle GoldenGate

 

Course Details

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

 

---