Oracle Golden Gate 11G Online Training

[cssadhar]

 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 Logsb

 

Contact Us:309-200-3848