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 Logs

 

Contact Us:309-200-3848