Description

This Oracle GoldenGate 12c: Fundamentals for Oracle training emphasis on Oracle-to-Oracle database replication. Expert instructors will deep dive into the Oracle GoldenGate architecture, walking professionals through different product features.

Radiant Teachlearning offers Oracle GoldenGate 12c: Fundamentals for Oracle Training Program in Classroom and Virtual instructor Led/Online mode.

 

Duration: 4 days

 

Learning Objectives

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

 

Benefits to You

Integrate your organization’s disparate data across heterogeneous databases for optimized decision-making. Become more efficient at configuring and executing Oracle GoldenGate.

 

Install GoldenGate Installation & Command Line

Professionals will learn to install Oracle GoldenGate as well as prepare target environments and the source. Enrolling in this training program teaches professionals way to use the Oracle GoldenGate command line interface (GGSCI) efficiently.

 

Learn GoldenGate Configuration Processes

Professionals will also develop the understanding and skills to configure Change Delivery (Replicat), Change Capture (Extract) and Initial Load. Professionals will learn way to extract trails and files using Data Pump, create parameter files and manage and maintain Oracle GoldenGate instances.

 

Uni- and Bi-Directional Replication

Capture of both DDL as well as DML will be configured for both bi-and uni- directional replication with collision detection.

 

Explore New Features in 12c

Features new to 12c, for example Integrated Apply and Wallet, are highlighted along the way. This training program is based on Oracle GoldenGate version 12.1.2. Please note: labs are done in Linux.

Pre-requisites

Audience Profile

  • Administrator
  • Analyst
  • Architect
  • Database Administrator
  • Developer
  • Implementer
  • System Integrator

Course Content

Technology Overview

  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets

Oracle GoldenGate Architecture

  • 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

Installing Oracle GoldenGate

  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.

Configuration Overview and Preparing the Environment

  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package

Configuring Change Capture (Extract)

  • 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

Configuring Change Delivery (Replicat)

  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat

Configuring Extract Trails and Files (Data Pump)

  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps

Performing Initial Load

  • 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 Configuration Parameters

  • Filtering and Data Selection
  • Additional Transformation Concepts

Configuration Options

  • Bidirectional Replication
  • DDL Replication

FAQs

Q: What kind of audience is expected for this training?

 

A: This training is recommended for the following professionals:-

  • Administrator
  • Analyst
  • Database administrator
  • Developer
  • Implementer
  • System Integrator

 

Q: What is the role of Golden gate?

 

A: The Golden Gate is high performance software for real time data transactional change and offers bidirectional data replication.

 

Q: What is the role of Data pump?

 

A: Data pump enables a very high speed data transfer from one database to another database.

 

Q: What is the meant by log dump?

 

A: Log dump is the standard utility which allows users to scan and save the transaction records with the OGG trails.

 

Q: What is meant by Golden Gate RBA?

 

A: Relative Byte Address is the exact location of the trail file of the current transaction.

 

Q: What is Bi-Directional replication in Golden Gate?

 

A: It’s active to active replication which captures data from multiple databases and concludes with a single format synchronized data. This replication is implemented for the result of high availability.

 

Q: Why one should prefer Radiant Techlearning ?

 

A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.

 

Q: What if I/we have doubts after attending your training program?

 

A: Radiant team of experts would be available on the e-mail support@radianttechlearning.com to answer your technical queries even after the training program.

 

Q: Does this training program include any project?

 

A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.

 

Q: If I face technical difficulty during the session then is there any remedy for that?

 

A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.

 

Q: What is schedule of training program?

 

A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch