Course Details

Oracle Golden Gate Online Training

Contact Us

Oracle Golden Gate Course Overview:

Oracle GoldenGate has generated a lot of buzz in the Oracle community since this was acquired by Oracle Corporation in 2009. The GoldenGate product is marketed by Oracle as a niche application, but one that can be of use in nearly any Oracle environment.  Additionally, Oracle has made it clear that they expect GoldenGate to be the chief replication method in the future instead of Streams of Advanced Replication.

Oracle Golden Gate Course Content:

  • Introduction to Oracle Golden Gate 11g: Fundamentals for Oracle
  • Objectives
  • Oracle Golden Gate 11g
  • Key Capabilities & Technology Differentiators
  • Value Propositions for Oracle Golden Gate
  • Oracle Golden Gate Topologies
  • Oracle middleware for Business Intelligence
  • Oracle Data Integrator EE & Oracle Golden Gate
  • Oracle Golden Gate for Real-Time Data Warehousing
  • Oracle Golden Gate Solutions for Oracle Database
  • Oracle Golden Gate for Oracle Database Eliminate down Time for Migrations and Application upgrades
  • Oracle Golden Gate for Oracle Database Eliminate down Time during Oracle Database upgrades
  • Oracle Golden Gate for Oracle Database Eliminate up planned Down Time with Active Data Guard and Oracle Golden Gate
  • Oracle Golden Gate for Oracle Database Improve Production System Performance and Lower costs
  • Oracle Golden Gate for Operational Reporting
  • Oracle Golden Gate for Oracle Database Increase Returns on Investment on Existing Servers and Synchronize Global Data

Technology Overview

  • Oracle Golden Gate: Modular Building Blocks
  • Supported Databases and Operating systems
  • Oracle Golden Gate Product Line
  • Oracle Golden Gate Veridata
  • Oracle Golden Gate Director: Overview
  • Oracle Golden Gate Monitor: Overview
  • Adapter Integration Options for Oracle Golden Gate
  • Oracle Golden Gate for Flat File
  • Oracle Golden Gate Application Adapter for Java
  • JMS Messaging Capture

Oracle Golden Gate Architecture


  • Oracle Golden Gate Uses
  • Oracle Golden Gate Components
  • Oracle Golden Gate Logical Architecture
  • Oracle Golden Gate Process Groups
  • Parameter Files
  • Change Data Capture and Delivery
  • Change Data Capture and Delivery using a Data Pump
  • Running an Initial Load
  • Initial Load
  • Checkpoints
  • Check pointing
  • Commit Sequence Number (CSN)

Installing Oracle Golden Gate

  • System Requirements
  • Operating System Requirements
  • Downloading Oracle Golden Gate
  • Installation on UNIX, Linux or Z/OS
  • Installation on Windows
  • Oracle Golden Gate Directories
  • Oracle Golden Gate Documentation
  • GGSCI Command Interface
  • GGSCI Commands
  • GGSCI Command Examples
  • OBEY Files
  • New Oracle Golden Gate 11g R1 GGSCI Miscellaneous Commands
  • Running Oracle Golden Gate from the OS Shell

Configuration Overview and Preparing the Environment 

  • Configuring Oracle Golden Gate
  • Preparing the Environment: Oracle Database
  • Preparing the Environment: Manager Overview
  • Preparing the Environment: Configuring Manager
  • Preparing the Environment: Sample Manager Parameter File
  • Preparing the Environment: Overview of Source Definitions
  • Preparing the Environment: Running defgen

Configuring Change Capture

  • Step 2: Change Capture
  • Extract Overview
  • Data pump Overview
  • Data pump: One-to-many Trails
  • Data pump: One-to-many Target Systems
  • Setting up Change Capture
  • Add Extract Command
  • Add Extract Examples
  • Editing Extract Parameters
  • Passive Alias Extract
  • Overview of Trails
  • Adding a Local or Remote Trail
  • Starting the Extract
  • Primary Extract Configuration for Oracle
  • Data pump Configuration for Oracle
  • Automatic Storage Management (ASM)
  • Ensuring ASM Connectivity

Configuring Initial Load

Step 3: Initial Load
  • Objectives
  • Initial Load: Advantages of Oracle Golden Gate Methods
  • Initial Load: Resource Limitations
  • Prerequisites for Initial Load
  • Initial Load: Oracle Golden Gate Methods
  • Initial Load: File to Replicate
  • Initial Load: File to Database Utility
  • Initial Load: Direct Load
  • Initial Load: Direct Bulk Load (to Oracle)

Configuring Change Delivery

  • Step 4: Change Delivery
  • Replicate Overview
  • Change Delivery Tasks
  • Checkpoint Table
  • Sample Configuration
  • Avoiding Collisions with Initial Load
  • Handling Collisions with Initial Load

Extract Trail and Files

  • Overview of Extract Trails and Files
  • Extract Trails and Files Distribution
  • Extract Trails and Files Contents
  • Extract Trails and Files Clean up
  • Trail Format
  • Record Header Area
  • Record Data Area
  • Setting the Compatibility Level
  • Alternative Trail Formats
  • FORMATASCII Sample Output
  • FORMATSQL Sample Output
  • FORMATXML Sample Output
  • Log dump Utility
  • Opening a Trail
  • Setting up a View
  • Viewing the Trail file Header
  • Viewing Trail Records
  • Counting Records in the Trail
  • Filtering by a File name
  • Locating a Hex Data Value
  • Saving Records to a new Trail
  • Keeping a Log of Your Session
  • Overview of the Reverse Utility
  • Overview Process of the Reverse Utility
  • Reverse: Overview Process
  • Sample Parameter Files

Oracle Golden Gate Parameter

  • Oracle Golden Gate Parameter Files
  • Using Parameter Files
  • Global versus Process Parameters
  • Global Parameters
  • Manager Parameters: Overview
  • Sample Manager Parameter File
  • Manager Parameter Categories
  • Extract Parameter Overvie
  • Extract Parameter Defaults
  • Sample Extract Parameter File
  • Extract Parameter Categories
  • Extract Example: Table Parameter
  • Extract Example: Tranlogoptions Paramete
  • Replicat Parameter Overview
  • Replicat Parameter Defaults
  • Sample Replicat Parameter File
  • Replicat Parameter Categories
  • Replicat Example: MAP Parameter
  • Db options

Data Selection and Filtering

  • Overview of Data Mapping and Manipulation
  • Types of Definition Files
  • Data Selection: Overview
  • Data Selection: WHERE Clause
  • Data Selection: WHERE Clause Examples
  • Data Selection: FILTER Clause
  • Data Selection: FILTER Clause Examples
  • Data Selection: RANGE Function
  • Data Selection: RANGE Function Example
  • Column Mapping: Overview
  • Column Mapping: Example
  • Column Mapping: Building History
  • Data Transformation using Functions
  • Functions: Performing Tests on Column Values
  • @IF Functions
  • Functions: Working with Strings and Numbers
  • @STRCAT Function
  • STREXT Function
  • Other Functions
  • Overview of SQLEXEC
  • SQLEXEC: Basic Functionality
  • SQLEXEC: DBMS and Data Type Support
  • SQLEXEC: Using with a LOOKUP Stored Procedure
  • SQLEXEC: Using with a SQL Query
  • SQLEXEC: Using within a TABLE or MAP Statement
  • SQLEXEC: Using as a Stand-Alone Statement

Additional Transformation Topics

  • Overview of Macros
  • Creating Macros
  • Invoking a Macros
  • Reusing Parameter Sets
  • Creating Macros Libraries
  • Tracing Macro Expansion
  • Overview of User Tokens
  • Environmental Values Available to @ GETENV
  • User Tokens Display
  • Using User Tokens
  • Viewing User Exits in Log dump
  • Overview of User Exits
  • Uses for User Exits
  • User Exits: High-Level Processing Logic
  • Implementing User Exits
  • User Exit Parameters
  • Sample User Exits
  • Calling User Exits
  • Overview of Oracle Sequences

Configuration Options Objectives

  • Overview of BATCMSQL
  • BATCHSQL Syntax
  • BATCHSQL Results
  • Compression Options
  • Example: Of Compression
  • Encryption Overview
  • Message Encryption
  • Options: Message Encryption
  • Trial or Extract File Encryption
  • Password Extract File Encryption Method 1
  • Password Extract File Encryption Method 2
  • Summary of Password
  • Event Market System
  • Uses for Event Actions
  • Event Actions Flows Chart
  • Implementing Event Actions
  • Event Actions: Heartbeat Example
  • Event Actions: Auto Mated Switchover Example

Bidirectional Replication

  • Bidirectional Flowchart
  • Capabilities of a Bidirectional Configuration
  • Issues to Consider For a Bidirectional Configuration
  • Preventing Data Looping
  • Loop Detection Techniques
  • Conflict Avoidance and Detection
  • Conflict Detection by Filter
  • Conflict Resolution
  • Conflict Resolution: Example
  • Conflict Resolution by Applying Net Differences
  • Oracle Sequence Numbers
  • Truncate Table Operations

DDL Replication 

  • Overview of DDL Replication
  • DDL Replication Requirements and Restrictions
  • Characteristics for DDL Replication
  • DDL Scopes
  • Using Unqualified Object Names
  • DDL Parameter
  • DDL String Substitution
  • Error Handling
  • DDL Options for Oracle
  • Mapping Schemas
  • Supporting DDL in an Active –Active Bidirectional Configuration
  • Activating Oracle DDL Capture

Tuning and Troubleshooting 

  • Using Command Security
  • Sample CMDSEZC Statements
  • Managing Trail Files
  • Handing TCP/IP Errors
  • TCPERRS File
  • Troubleshooting Oracle Golden Gate
  • Oracle Golden Gate Monitor
  • Obtaining Process Information through GGSCI
  • Using the Error Log
  • Process Reports
  • Sample Extract Process Report
  • Discard Files
  • Using the System Logs

Post a Comment


Home static_page

Popular Posts

Random Posts

Flickr Photo