Oracle Golden Gate 11g Training

Oracle Golden Gate 11g Online Training

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

  • Objectives
  • 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

  • Objectives
  • Oracle Golden Gate Uses
  • Oracle Golden Gate Components
  • Oracle Golden Gate Logical Architecture
  • Oracle Golden Gate Process Groups
  • GGSCI
  • 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

  • Objectives
  • 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

  • Objectives
  • 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

  • Objectives
  • 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

  • Objectives
  • Step 3: Initial Load
  • 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

  • Objectives
  • 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

  • Objectives
  • 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
  • FORMATASCII Sample Output
  • FORMATSQL
  • FORMATSQL Sample Output
  • FORMATXML
  • 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

  • Objectives
  • 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 Overview
  • Extract Parameter Defaults
  • Sample Extract Parameter File
  • Extract Parameter Categories
  • Extract Example: Table Parameter
  • Extract Example: Tranlogoptions Parameter
  • Replicat Parameter Overview
  • Replicat Parameter Defaults
  • Sample Replicat Parameter File
  • Replicat Parameter Categories
  • Replicat Example: MAP Parameter
  • Db options

Data Selection and Filtering

  • Objectives
  • 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

  • Objectives
  • 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

  • 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

  • Objectives
  • 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

  • Objectives
  • 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

  • Objectives
  • 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

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message