Oracle GoldenGate 11g Fundamentals for HP NonStop

Oracle GoldenGate 11g Fundamentals for HP NonStop gives an overview of the Oracle Golden Gate architecture. This course covers the configuration of Oracle GoldenGate for replication of transactional data across two HP NonStop databases (Enscribe or SQL/MP).

This course provides presentations and hands-on practice of the commands, parameters, functions and features for installing and configuring Oracle GoldenGate for replication. Hands on Practices and labs help the participants understand the techniques for low-impact capture, routing, transformation, and delivery of database transactions across heterogeneous environments in real-time.

Learn To:

• Install Oracle GoldenGate
• Issue GGSCI commands
• Configure Change Capture
• Configure Initial Load
• Configure Change Delivery
• Extract trails and files

This course is based on Oracle Golden Gate version 11.1.1.

Audience

• Database Administrators
• System Administrator
• Data Warehouse Administrator

Course Topics Oracle GoldenGate Features and Functionality Oracle GoldenGate Architecture

• Oracle GoldenGate Process Groups
• Uses for GoldenGate Extract
• Change Data Capture and Delivery
• Change Data Capture with a Data Pump
• Initial Load with GoldenGate Extract
• GoldenGate Checkpointing
• GoldenGate Parameter Files

Installing Oracle GoldenGate

• Download the Media Pack
• Installation on HP NonStop
• Locate and Use Oracle GoldenGate Documentation

Configuring and Preparing the GoldenGate Environment

• Configuring the Manager Process
• Starting the Manager Process

Configuring the Initial Load Configuring Change Capture in Audited Environments

• Configuring and Starting an Extract Process
• Adding Local and Remote Trails
• Configuring and Starting a Data Pump
• Configure Change Capture using TMF Audit Trails

Configuring Change Capture in Non-Audited Environments

• Capture Changed Data Directly from Non-audited Entry-sequenced Files
• Capture Changed Data Directly from Non-audited Relative Files
• Configure Change Capture using Logger
• Configure Change Capture using Direct Read

Configuring Change Delivery

• Configure and Start a Replicat Process
• Handling Collisions with Initial Load

Oracle GoldenGate Commands

• Run GoldenGate Commands from the GGSCI Prompt
• Run GoldenGate Commands from Obey Files
• Run GoldenGate Commands from the OS Shell

Oracle GoldenGate Parameters

• Edit Parameter Files
• Contrast GLOBALS with Process Parameters
• Editing Parameter Files
• Manager Parameters
• Logger Parameters
• Server Collector Parameters
• Extract Parameters
• Replicat Parameters

Oracle GoldenGate Utilities

• DEFGEN - Generate Dource Definitions
• DDLGEN - Generate Target Table Definitions
• SYNCFILE - Manage Duplication of Non-database Files
• REVERSE - Dynamic Rollback
• LOGDUMP - Analyze GoldenGate Trails
• MEASFLS - Collect Measure Statistics for Sizing
• MEASRPT - Report on Measure Statistics for Sizing
• SFGEXT - Checks if GoldenGate Library is Bound In

Data Mapping and Transformation

• Select and Filter Data for Replication
• Map Columns Between Different Schemas
• Use Built-in Functions
• Use SQLEXEC to Interact Directly with a Database
• Create and Invoke Macros
• Set and Retrieve User Tokens
• Run User Exits in GoldenGate processes

Configuration Options

• Use BATCHSQL to Speed Delivery
• Use Data Compression Across the Network
• Use Message, Trail and Password Encryption
• Handle Bidirectional Issues
• Use Event Records to Automatically Trigger Actions

Managing Oracle GoldenGate

• Control Command Permissions
• Manage Trail Files
• Handle TCP/IP Errors
• Use Reporting
• Monitor Processes, Lags and Error Messages
• Troubleshoot Problems
• Get Technical Support

Course Objectives

• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Install Oracle GoldenGate software
• Configure Oracle GoldenGate for replication between 2 NonStop databases (Enscribe or SQL/MP)
• Use Oracle GoldenGate utilities
• Use Oracle GoldenGate to perform data transformation
• Run and manage Oracle GoldenGate instances