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

 

 

Contact Us:309-200-3848

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