Nowoczesna Firma
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników

Oracle GoldenGate 12c: Fundamentals for Oracle (D84357GC10)

Tablet Lenovo (7"/8GB/WiFi/Android) gratis*!

Do szkoleń autoryzowanych Oracle 3, 4 lub 5 dniowych w formacie ILT, zamówionych w Database Consulting.
*Promocja ważna do wyczerpania zapasów lub do odwołania i nie łączy się z innymi promocjami ani zniżkami


Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia


Dla kogo

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

Czas trwania

4 dni

Cena bazowa

PLN 5960


  • 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


This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.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.Benefits to YouIntegrate your organization's disparate data across heterogeneous databases for improved decision-making. Become more efficient at configuring and implementing Oracle GoldenGate.Install GoldenGate Installation Command LineYou'll learn to install Oracle GoldenGate and prepare the source and target environments. Enrolling in this course teaches you how to use the Oracle GoldenGate command line interface (GGSCI) efficiently.Learn GoldenGate Configuration ProcessesYou'll also develop the knowledge and skills to configure Change Capture (Extract), Change Delivery (Replicat) and Initial Load. You'll learn how to extract trails and files using Data Pump, create parameter files and manage Oracle GoldenGate instances.Uni- and Bi-Directional ReplicationCapture of both DML and DDL will be configured for both uni- and bi-directional replication with collision detection.Explore New Features in 12cFeatures new to 12c, such as Integrated Apply and Wallet, are highlighted along the way. This course is based on Oracle GoldenGate version 12.1.2. Please note that the labs are done in Linux.


  1. 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
  2. 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
  3. Installing Oracle GoldenGate
    • Listing System Requirements
    • Performing Installation
    • Configuring Environment Variables
    • Using GGSCI
    • Running Oracle GoldenGate from the OS shell.
  4. 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
  5. 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
  6. Configuring Change Delivery (Replicat)
    • Reviewing Replicat Overview
    • Configuring Replicat Tasks
    • Configuring a Sample Environment
    • Configuring New Integrated Replicat
  7. 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
  8. 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
  9. Editing Configuration Parameters
    • Editing Parameter Files
    • Contrasting GLOBALS versus Process Parameters
    • Configuring GLOBALS Parameters
    • Configuring Manager Parameters
    • Configuring Extract Parameters
    • Configuring Replicat Parameters
  10. Filtering and Data Selection
    • Filtering and Data Selection
    • Mapping Columns Between Different Schemas
    • Using Built-in "@" (at) Functions
    • Using SQLEXEC to Interact Directly with a Database
    • Configuring New Coordinated Replicat
  11. Additional Transformation Concepts
    • Configuring and Using Macros
    • Configuring and Using User Tokens
    • Configuring and Using User Exits
    • Configuring and Using Oracle Sequences
  12. Configuration Options
    • Configuring and Using BATCHSQL
    • Configuring and Using Compression
    • Configuring and Using Encryption
    • Configuring and Using Event Actions
    • Configuring New Wallet Security
  13. Bidirectional Replication
    • Reviewing Bidirectional Considerations
    • Detecting Loops
    • Avoiding Conflicts
    • Configuring and Using Conflict Detection and Resolution
    • Describing Identity Types Issues
  14. DDL Replication
    • Reviewing Data Description Language Replication Overview
    • Configuring and Using Options for DDL Replication
    • Configuring and Using String Substitution in DDL


    • Familiarity with Oracle Database and basic SQL using SQL*Plus
    • Familiarity with basic encryption techniques
    • Familiarity with editing Linux text files using gedit or vi

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.