Oracle GoldenGate 11g Fundamentals for DB2

The Oracle GoldenGate 11g Fundamentals for DB2 course focuses on DB2-to-Oracle data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances. The material presented in the lessons is complemented with hands-on lab practices, which guide the participants through exercises of increasing complexity until the subject matter is mastered by all participants.

Learn To:

• Install Oracle GoldenGate software version 11.1.1.1.1
• Configure Oracle GoldenGate for DB2-to-DB2 replication
• Master Oracle GoldenGate utilities such as logdump
• Perform data transformation
• Configure and manage Oracle GoldenGate instances
• Describe Oracle GoldenGate architecture

This course is based on Oracle Golden Gate version 11.1.1.

Audience

• Database Administrators
• Architect
• Database Designers
• System Integrator

Course Topics Learning Oracle GoldenGate Solutions

• What is Oracle GoldenGate?
• Discussing Oracle GoldenGate Use Cases
• Describing Oracle GoldenGate Topologies
• About Oracle Management Pack for Oracle GoldenGate

Understanding Oracle GoldenGate Concepts

• Describing GoldenGate parameters, process groups and commands
• About DB2 Capture and Delivery Methods
• Describing how GoldenGate uses checkpointing to allow recovery

Installing Oracle GoldenGate

• Downloading the media pack
• Installing on Windows
• Installing on Linux and UNIX
• Finding and Installing Oracle GoldenGate Documentation

Using Oracle GoldenGate Commands

• Getting help information on GGSCI commands
• Identifying the types of GGSCI commands available
• Running GoldenGate commands, from the GGSCI prompt, obey files and OS shell

Configuring Oracle GoldenGate and Preparing the Environment

• About Configuration overview
• Explaining Oracle GoldenGate Manager Process
• Preparing Source Database for Replication

Configuring Change Capture

• Configuring Oracle GoldenGate for Change Capture from DB2
• Configuring Oracle GoldenGate Data Pumps

Configuring Initial Load

• Understanding how to perform initial data load (database synchronization)
• About Initial Load Methods
• Explaining Database Vendor Specific Load Methods
• Explaining Oracle GoldenGate Synchronization Methods
• Discussing advantages of GoldenGate Methods

Managing Oracle GoldenGate

• Understanding the Management facilities available in Oracle GoldenGate
• Automating Process Startup
• Managing Trail Files
• Handling TCP/IP errors
• Reporting and Interpreting Replication Statistics
• Monitoring Processes, Lags and Error Messages
• Learning how to obtain Technical Support

Configuring Change Delivery

• Explaining what the Replicat Process Does
• Configuring and Starting a Replicat Process
• Configuring Replicat to handle Collisions between Changes and the Initial Data Load

Examining Extract Trails and Files

• Understanding Extract Trails and Files indepth
• About Canonical Trail Format Overview
• Understanding the LogDump Utility
• Using LogDump to Troubleshoot Replication Issues

Understanding the Variety of Oracle GoldenGate Configuration Parameters

• Editing Parameter Files for Extract and Replicat Processes
• Comparing and Contrasting GLOBALS with Process Parameters
• Mastering Commonly-Used Parameters for GLOBALS, Manager, Extract and Replicat Processes

Understanding Data Mapping and Transformations

• Selecting and Filtering Data for Replication
• Using Column Mapping
• Interacting Directly with the Database through the Use of SQLEXEC
• Using Macros, Tokens and User Exits to Enrich Data Transformation

Mastering Additional 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, Conflict Detection and Teradata Identity Columns

Course Objectives

• Use Oracle GoldenGate for DB2 Utilities
• Perform Data Transformation using Oracle GoldenGate
• Run and Manage Oracle GoldenGate Instances
• Describe Oracle GoldenGate Solutions
• Describe Oracle GoldenGate Architecture
• Install Oracle GoldenGate software on Windows and Linux
• Configure Oracle GoldenGate for DB2-to-DB2 Data Replication
• Configure Oracle GoldenGate for DB2-to-Oracle Data Replication