> > > D66519

Oracle GoldenGate 11g: Fundamentals for Oracle (D66519)

Kursbeschreibung Kurstermine
 

Kursüberblick

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.

Learn To:

  • 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

This course is based on Oracle Golden Gate version 11.2.1.

Zielgruppe

  • Data Warehouse administrators
  • Data Warehouse analysts
  • Database administrators
  • Database designers
  • Technical consultants

Voraussetzungen

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

Kursziele

  • 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

Kursinhalt

  • Oracle GoldenGate 11gR1 Introduction
  • Understanding Oracle GoldenGate: Overview
  • Oracle GoldenGate Architecture
  • Installing Oracle GoldenGate
  • Configuration Overview and Preparing the Environment
  • Configuring Change Capture
  • Configuring Initial Load
  • Configuring Change Delivery
  • Extracting Trails and Files
  • Working with Parameters
  • Using Data Selection and Filtering
  • Using Additional Transformation Concepts
  • Introducing Configuration Options
  • Configuring Bidirectional Replication
  • Setting Up DDL Replication
  • Tuning and Troubleshooting
Classroom Training
Modality: G

Dauer 4 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.680,- €
  • Schweiz: Fr. 3.312,-
Termine und Buchen
Online Training
Modality: U

Dauer 4 Tage

Termine und Buchen
E-Learning Oracle Training on Demand
Modality: P
Preis (exkl. MwSt.)
  • Deutschland: 2.340,- €
  • Schweiz: Fr. 2.864,-
E-Learning kaufen
 
Kurstermine

Derzeit gibt es keine Trainingstermine für diesen Kurs.  Termin anfragen

 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.