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