Oracle Goldengate

 

IT Trainings provides Oracle Golden Gate Online & Classroom Training course by excellent experienced IT professionals. Our trainer has good training experience so that best quality output will be delivered.

COURSE CONTENT

 

Introduction

    • Discussing Required versus Suggested Knowledge
    • Listing Course Objectives
    • Discussing Course Non-Objectives (available as other follow-on courses)

Technology Overview

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

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

Installing Oracle GoldenGate

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

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

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

Configuring Change Delivery (Replicat)

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

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

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

Editing Configuration Parameters

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

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

Additional Transformation Concepts

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

Configuration Options

      • Configuring and Using BATCHSQL
      • Configuring and Using Compression
      • Configuring and Using Encryption
      • Configuring and Using Event Actions

Bidirectional Replication

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

DDL Replication

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

Tuning and Troubleshooting

      • Controling Command Persionns
      • Managing Trail Files
      • Automating Process Setup
      • Restarting Oracle GoldenGate
      • Handling TCP/IP Errors
      • Using Reporting and Statistics
      • Monitoring Processes, Lags and Error Messages
      • Features of GoldenGate Management Pack