Oracle GoldenGate 12c: Fundamentals for Oracle Training

• Install GoldenGate and issue the Oracle GoldenGate command line interface (GGSCI) efficiently
• Prepare the source and target database (assumes Oracle-to-Oracle replication)
• Use Oracle GoldenGate products and environments to design the replication solutions and manage multiple Oracle GG instances
• Configure, and monitor Change Capture (Extract), and Change Delivery (Replicat)
• Perfom Initial Load and edit configuration parameters
• Manage Extract trails and files using Data Pump
• Use  encryption and compression to control network transmission
• Use macros, user tokens, user exits, Oracle Sequences to transform data

• Data Warehouse Developer
• Data Warehouse Analyst
• Data Warehouse Administrator
• Database Designers
• Database Administrators
• System Integrator
• Technical Consultant
• Configuration Consultant

• Basic understanding of Oracle Database and basic SQL using SQL*Plus
• Conceptual  idea of editing Linux text files using gedit or vi
• Knowledge of basic encryption techniques will be an added advantage

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

• Editing Parameter Files
• Contrasting GLOBALS versus Process Parameters
• Configuring GLOBALS Parameters
• Configuring Manager Parameters
• Configuring Extract Parameters
• Configuring Replicat Parameters

10. Filtering and Data Selection

• Filtering and Data Selection
• Mapping Columns Between Different Schemas
• Using Built-in "@" (at) Functions
• Using SQLEXEC to Interact Directly with a Database
• Configuring New Coordinated Replicat

11. Additional Transformation Concepts

• Configuring and Using Macros
• Configuring and Using User Tokens
• Configuring and Using User Exits
• Configuring and Using Oracle Sequences

12. Configuration Options

• Configuring and Using BATCHSQL
• Configuring and Using Compression
• Configuring and Using Encryption
• Configuring and Using Event Actions
• Configuring New Wallet Security

13. Bidirectional Replication

• Reviewing Bidirectional Considerations
• Detecting Loops
• Avoiding Conflicts
• Configuring and Using Conflict Detection and Resolution
• Describing Identity Types Issues

14. DDL Replication

• Reviewing Data Description Language Replication Overview
• Configuring and Using Options for DDL Replication
• Configuring and Using String Substitution in DDL