Oracle GoldenGate Course Content

Course Outline

Oracle GoldenGate 12 C R1 Introduction

• Oracle GoldenGate Features and Functionality

• Oracle Middleware for Business Intelligence

• Oracle GoldenGate High Availability and Disaster Tolerance Solutions

• Oracle GoldenGate Real-time Data Integration Solutions

Oracle GoldenGate: Overview

• Oracle GoldenGate Functionality and Components

• Supported Databases and Platforms

• Oracle GoldenGate Product Line

Oracle GoldenGate Architecture

• Oracle GoldenGate Process Groups

• Change Capture and Delivery (with and without a Data Pump)

• Initial Data Load

• Contrasting Batch and Online Operation

• Oracle GoldenGate Check pointing

• Commit Sequence Number (CSN)

• 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

• Types of GGSCI Commands Available

Configuration Overview and Preparing the Environment

• 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

• Extract Process

• Marking Tables with TRANDATA

• Configuring Extract to Access Logs on Oracle ASM

• Configuring and Starting an Extract Process

• Adding Local and Remote Trails

• Configuring and Starting an Extract Data Pump

Configuring Initial Load

• Oracle Golden Gate Initial Load Methods

• Variety of Database-Specific Methods

• Advantages of Oracle Golden Gate Methods

• Configuring an Initial Load Using Oracle Golden Gate

Configuring Change Delivery

• Replicate Process

• Adding, Configuring, and Starting a Replicate Process

• Avoid and Handle Collisions between Changes and the Initial Load Data

Extracting Trails and Files

• Extract Trails vs. Files

• Investigating Different Formats

• Viewing Extract Trails and Files with Log dump

• 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

• Commonly-Used Parameters for GLOBALS, Manager, Extract, and Replicat

Using Data Selection and Filtering

• Selecting and Filtering Data for Replication

• Mapping Columns between Different Schema

• Using Built-In Functions

• Using SQL EXEC to Interact Directly with a Database

Using Additional Transformation Concepts

• Creating and Invoking Macros

• Setting and Retrieving User Tokens

• Running User Exits in Golden Gate Processes

• Replicating Oracle Sequences

Configuration Options

• Using BATCHSQL to Speed Delivery

• Data Compress across the Network

• Enabling Message, Trail, and Password Encryption

• Using Event Records to Automatically Trigger Actions

Configuring Bidirectional Replication

• Bidirectional Configuration

• Detecting and Avoid Loops

• Avoiding, Detecting, and Handling Conflicts

• Handling Identity Types

Setting up DDL Replication

• Concept of DDL Replication

• Requirements for Oracle DDL Replication

• GoldenGate Options for DDL Replication

• DDL String Substitution

Tuning and Troubleshooting

• Controlling Command Permissions

• 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