Golden Gate Course

Course Objectives:

Describe Oracle GoldenGate architecture
Install Oracle GoldenGate software on Linux or Windows
Configure Oracle GoldenGate for Oracle-to-Oracle replication
Use Oracle GoldenGate utilities
Perform data transformation
Run and manage Oracle GoldenGate instances
Describe Oracle GoldenGate solutions

Course Topics:

Oracle GoldenGate Evolution & Solutions

Understanding transactional data management
Describing Oracle GoldenGate high availability and disaster tolerance solutions
Describing Oracle GoldenGate real-time data integration solutions

Oracle GoldenGate Technical Overview

Understanding Oracle GoldenGate functionality and components
List supported databases and platforms
Identify the advantages of Oracle GoldenGate
Describing Oracle GoldenGate Director
Describing Oracle GoldenGate Veridata

Oracle GoldenGate Architecture

Describing Oracle GoldenGate uses
Explaining change capture and delivery with a data pump
Explaining change capture and delivery without a data pump
Explaining initial data load
Comparing batch and online operation
Explaining Oracle GoldenGate checkpointing
Describing Oracle GoldenGate parameters and process groups
Describing GGSCI commands

Installing Oracle GoldenGate

Installing Oracle GoldenGate on Linux, UNIX and Windows
Using Oracle GoldenGate documentation
Using the Oracle GoldenGate command interface

Configuring & Preparing the Environment

Describing the high-level configuration steps
Configuring the Manager process
Starting the Manager process
Generating a source definitions file
Preparing a source database for transaction capture

Oracle GoldenGate Commands

Running GoldenGate commands from the GGSCI prompt
Running GoldenGate commands from the obey files
Running GoldenGate commands from the OS shell
Identifying the types of GGSCI commands available

Configuring Change Capture

Describing the Extract process
Configuring and starting an Extract process
Adding local and remote trails
Configuring and starting a 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
Configuring a Replicat process
Starting a Replicat process
Configuring Replicat to handle collisions between changes and the initial load data

Extract Trails and Files

Describing Extract trails and files
Comparing Extract trails and files
Viewing Extract trails and files with Logdump
Reversing the sequence of operations in an Extract trail or file (to back out changes)

Oracle GoldenGate Parameters

Editing parameter files
Comparing GLOBALS with process parameters
Describing commonly-used parameters for GLOBALS
Describing commonly-used parameters for Manager
Describing commonly-used parameters for Extract
Describing commonly-used parameters for Replicat

Data Mapping and Transformation

Selecting and filtering data for replication
Mapping columns between different schemas
Using built-in functions
Using SQLEXEC to interact directly with a database
Creating and invoking macros
Setting and retrieving user tokens
Running user exits in GoldenGate processes
Replicating Oracle sequences

Configuration Options

Using BATCHSQL to speed delivery
Using data compression across the network
Using message, trail and password encryption
Using event records to automatically trigger actions
Handling bidirectional issues, such as loop detection and conflict detection
Replicating Oracle DDL changes

Managing Oracle GoldenGate

Controlling command permissions
Managing trail files
Automating process startup
Handling TCP/IP errors
Using reporting and statistics
Monitoring processes, lags and error messages

Shopping Cart Software

Quick Contact