Oracle GoldenGate 10.4 Fundamentals of Transactional Data Management

This class covers typical Oracle GoldenGate implementations for managing transactional data across heterogeneous database and system platforms. The practices show Oracle to Oracle replication. This course provides an understanding of how participants can accomplish the business goals using Oracle for Transactional Data Management (TDM). Participants will understand all of the Oracle GoldenGate options available to meet the data replication requirements. This course also provides participants with the skills and information to optimally configure and operate Oracle GoldenGate.

This course is based on Oracle Golden Gate version 10.4.

Audience

• System Integrator
• Database Administrators
• Administrator

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

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