Oracle GlodenGate Training

Oracle GoldenGate

Make an Appointment
Description

Description

Oracle GlodenGate Training at Massive Tech – The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course focuses on Oracle-to-Oracle databasereplication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participantslearn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to use theOracle 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 parameterfiles, and to manage Oracle GoldenGate instances. Capture of both DML and DDL will be configured for both uni- andbi-directional replication.

Learn To:

  1. Install Oracle GoldenGate on Linux and Windows platforms
  2. Issue GGSCI commands
  3. Configure, start, stop, and monitor Change Capture and Delivery processes
  4. Manage Extract trails and files using Data Pump and logdump
  5. Create parameter files to transform data
  6. Manage multiple Oracle GoldenGate instances
Prerequisites

Prerequisites

  • Familiarity with Oracle Database and basic SQL using SQL*Plus.
Key Features
line
  • LIVE Instructor-led Classes
  • 24x7 on-demand technical support for assignments, queries, quizzes, project, etc.
  • Flexibility to attend the class at your convenient time.
  • Server Access to Massive's Tech Management System until you get into your dream carrier.
  • A huge database of Interview Questions
  • Professional Resume Preparation
  • Earn a Skill Certificate
  • Enroll today and get the advantage.
Curriculum
line
  • Discussing Required versus Suggested Knowledge
  • Listing Course Objectives
  • Discussing Course Non-Objectives (available as other follow-on courses)
  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle Goldengate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
  • Describing Oracle GoldenGate Process Groups
  • Explaining change Capture and Delivery (with and without a data pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Configuring Direct Load Methods
  • Handling Collisions with Initial Load
  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
  • Filtering and Data Selection
  • Mapping Columns Between Different Schemas
  • Using Built-in “@” (at) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL

Have Any Questions?

We are happy to answer any questions and we appreciate every feedback about our work!