Oracle GoldenGate 11g: Fundamentals for Oracle Training Logo

Oracle GoldenGate 11g: Fundamentals for Oracle Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

Print Preview The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course provides presentations and hands-on practice of the commands, parameters, functions and features for installing and configuring Oracle GoldenGate for Oracle-to-Oracle database replication on a Linux or Windows platform.This course is based on Oracle Golden Gate version 11.2.1.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is 11g fundamentals for oracle training Certification Training about?

The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course focuses on Oracle-to-Oracle database replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to use the Oracle GoldenGate command line interface (GGSCI) efficiently. Participants configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load. They learn to extract trails and files using Data Pump, create parameter files, and to manage Oracle GoldenGate instances. Capture of both DML and DDL will be configured for both uni- and bi-directional replication.

This course is based on Oracle Golden Gate version 11.2.1.

What are the objectives of 11g fundamentals for oracle training Certification Training ?

  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate on Linux and Windows platforms (the labs are Linux)
  • Prepare the source and target database environments (assumes Oracle-to-Oracle replication)
  • Issue GGSCI commands (batch Obey scripts and command-line interactive)
  • Configure, start, stop, and monitor Change Capture (Extract)
  • Configure, start, stop, and monitor Change Delivery (Replicat)
  • Configure, start, stop, and monitor Initial Load
  • Manage Extract trails and files using Data Pump and utilities such as logdump
  • Control network transmission using compression and encryption
  • Create parameter files
  • Transform data
  • Manage multiple Oracle GoldenGate instances

Who is 11g fundamentals for oracle training Certification Training for?

  • Data Warehouse Developer
  • Configuration Consultant
  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • System Integrator
  • Data Warehouse Analyst
  • Technical Consultant

What are the prerequisites for 11g fundamentals for oracle training Certification Training?

Suggested Prerequisite

  • Familiarity with Oracle Database and basic SQL using SQL*Plus.
  • Familiarity with Linux text editors such as vi or gedit

Available Training Modes

Live Online Training

32 Hours

Classroom Training

4 Days

Course Outline Expand All

Expand All

  • Listing Course Objectives
  • Discussing Required versus Suggested Knowledge
  • Discussing Course Non-Objectives (available as other follow-on courses)
  • Listing the Oracle Goldengate Product Line
  • Describing GUI Management Options
  • Listing Supported OS
  • Assembling Building Blocks
  • Listing Non-Database Sources and Targets
  • Listing Supported Databases
  • Reviewing Oracle GoldenGate Use Cases
  • Creating Oracle GoldenGate Topologies
  • Explaining Initial Data Load
  • Describing Commit Sequence Numbers (CSN)
  • Explaining change Capture and Delivery (with and without a data pump)
  • Contrasting Batch and Online Operation
  • Describing Oracle GoldenGate Files and Directories
  • Describing Oracle GoldenGate Process Groups
  • Explaining Oracle GoldenGate Checkpointing
  • Listing System Requirements
  • Configuring Environment Variables
  • Performing Installation
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
  • Assigning Oracle Database Roles/Privileges Required
  • Configuring Manager Process
  • Reviewing Configuration Overview
  • Creating Source Definitions
  • Preparing the Source Database
  • Accessing Logs on Oracle ASM
  • Extracting Use of Archived Transaction Logs
  • Adding Extract Group
  • Configuring Extract Tasks
  • Accessing Logs Remotely
  • Adding Trails
  • Reviewing Extract Overview
  • Editing Extract Parameters
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Describing Trail Formats
  • Configuring and Using Data Pumps
  • Reversing the Trail Sequence
  • Reviewing Extract Trails and Files Overview
  • Using Logdump for Viewing Trails
  • Oracle GoldenGate Methods
  • Configuring Direct Load Methods
  • Listing Database-specific Methods
  • Handling Collisions with Initial Load
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Contrasting GLOBALS versus Process Parameters
  • Configuring Extract Parameters
  • Configuring Manager Parameters
  • Configuring Replicat Parameters
  • Configuring GLOBALS Parameters
  • Editing Parameter Files
  • Mapping Columns Between Different Schemas
  • Using Built-in @ (at) Functions
  • Filtering and Data Selection
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Macros
  • Configuring and Using Oracle Sequences
  • Configuring and Using Event Actions
  • Configuring and Using Compression
  • Configuring and Using BATCHSQL
  • Configuring and Using Encryption
  • Describing Identity Types Issues
  • Detecting Loops
  • Configuring and Using Conflict Detection and Resolution
  • Avoiding Conflicts
  • Reviewing Bidirectional Considerations
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL
  • Reviewing Data Description Language Replication Overview

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

11g fundamentals for oracle training Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews