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