Course objectives

• Design replication solutions using Oracle GoldenGate products and environments
• Install Oracle GoldenGate and prepare the source and target database (assumes Oracle-to-Oracle replication)
• Issue GGSCI commands (batch Obey scripts and command-line interactive)
• Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load
• Manage Extract trails and files using Data Pump and utilities such as logdump
• Control network transmission using compression and encryption
• Transform data

Audience

• Administrator
• Analyst
• Architect
• Database Administrator
• Developer
• Implementer
• System Integrator

Course outline

1.Technology Overview

• Creating Oracle GoldenGate Topologies
• Reviewing Oracle GoldenGate Use Cases
• Assembling Building Blocks
• Listing Supported OS
• Listing Supported Databases
• Listing the Oracle GoldengGate Product Line
• Describing GUI Management Options
• Listing Non-Database Sources and Targets

2. 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 Numbers (CSN)
• Describing Oracle GoldenGate Files and Directories

3. Installing Oracle GoldenGate

• Listing System Requirements
• Performing Installation
• Configuring Environment Variables
• Using GGSCI
• Running Oracle GoldenGate from the OS shell.

4. Configuration Overview and Preparing the Environment

• Reviewing Configuration Overview
• Configuring Manager Process
• Creating Source Definitions
• Preparing the Source Database
• Assigning Oracle Database Roles/Privileges Required
• Using DBMS_GOLDENGATE_AUTH Package

5. Configuring Change Capture (Extract)

• Reviewing Extract Overview
• Accessing Logs on Oracle ASM
• Accessing Logs Remotely
• Configuring Extract Tasks
• Adding Extract Group
• Editing Extract Parameters
• Extracting Use of Archived Transaction Logs
• Adding Trails

6. Configuring Change Delivery (Replicat)

• Reviewing Replicat Overview
• Configuring Replicat Tasks
• Configuring a Sample Environment
• Configuring New Integrated Replicat

7. Configuring Extract Trails and Files (Data Pump)

• Reviewing Extract Trails and Files Overview
• Describing Trail Formats
• Using Logdump for Viewing Trails
• Reversing the Trail Sequence
• Configuring and Using Data Pumps

8. Performing Initial Load

• Oracle GoldenGate Methods
• Listing Database-specific Methods
• Describing Resource Limitations
• Listing Advantages of Oracle GoldenGate Methods
• Configuring File Load Methods
• Configuring Direct Load Methods
• Handling Collisions with Initial Load

9. Editing Configuration Parameters

10. Filtering and Data Selection

11. Additional Transformation Concepts

12. Configuration Options

13. Bidirectional Replication

14. DDL Replication