Oracle GoldenGate Online Training

Oracle GoldenGate Online Training



    Oracle Golden Gate training makes you an expert in concepts like how to Install Oracle Golden Gate,Configuring GLOBALS file,Comparing batch, DDL synchronization, Running Golden Gate commands from the OS shell, Controlling command permissions, and Manipulating Data ….etc.

    Course Content

    1.Introduction To Oracle Golden Gate

    • Introduction to Oracle Golden Gate
    • Understanding Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby
    • Database, and High Availability.
    • Supported databases and platforms
    • Advantages of Oracle Golden Gate

    2.Installing Oracle Golden Gate

    • Downloading the software
    • Installing Oracle Golden Gate
    • Explaining Subdirectories
    • Enabling supplemental logging

    3.Oracle Golden Gate Technology And Architecture

    • Understanding Golden Gate Components: Processes and Files
    • Process Data Flow
    • GoldenGate Architecture
    • Design Considerations

    4.Configuring & Preparing The Environment

    • Configuring the Manager process
    • Describing the Manager Parameters
    • Starting the Manager process
    • Configuring GLOBALS file
    • Configure Initial Load

    5.Data Definitions File

    • Overview of Data Definitions File
    • When to use Data Definitions Files
    • Types of Data Definitions File
    • Configuring Data Definitions File

    6.Configuring Change Capture Delivery – With And Without Data Pump

    • Preparing a source database for transaction capture
    • Describing the high-level configuration steps
    • Explaining change capture and delivery with a data pump
    • Explaining change capture and delivery without a data pump
    • Comparing batch and online operation
    • Explaining Oracle Golden Gate Checkpoints
    • Describing the Extract process
    • Configuring and starting an Extract process
    • Adding local and remote trails
    • Configuring and starting a data pump
    • Explaining the Replicate process
    • Configuring a Replicate process
    • Starting a Replicate process
    • Describing GGSCI commands
    • Describing Extract trails and files

    7.Configuring Change Capture Delivery – DDL Replication

    • Overview of DDL synchronization
    • Preparing a source database for transaction capture
    • Describing the high-level configuration steps
    • Configuring Extract and Replicate for DDL replication

    8.Oracle Golden Gate Commands

    • Running Golden Gate commands from the GGSCI prompt
    • Running Golden Gate commands from the obey files
    • Running Golden Gate commands from the OS shell
    • Identifying the types of GGSCI commands available

    9.Oracle Golden Gate

    • Managing trail files
    • Automating process startup
    • Using reporting and statistics

    10.GoldenGate Security Features

    • Using message, trail and password encryption
    • Controlling command permissions – CMDSEC file

    11.Advanced Configuration: Mapping And Manipulating Data

    • Overview of data mapping and manipulation
    • Deciding where data mapping and conversion will take place Data Selection and Filtering
    • Data Transformation

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies