Oracle Golden Gate 11G Online Training

[andharafriends]

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

 

Contact US:309-200-3848