Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    GoldenGateCourse Agenda

    Uploaded by

    Mohammad Mazheruddin
    This 19-20 hour course teaches Oracle GoldenGate for data replication and integration. It is intended for DBAs, developers, and technologists responsible for data replication and high availability. The course covers Oracle GoldenGate concepts, installation, architecture, configuration, DML and DDL replication, security, troubleshooting, and performance monitoring. Hands-on labs use Oracle 12c databases on Linux to demonstrate GoldenGate concepts. Upon completion, participants will have knowledge to work on GoldenGate projects.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    GoldenGateCourse Agenda

    Uploaded by

    Mohammad Mazheruddin
    37 views3 pages
    This 19-20 hour course teaches Oracle GoldenGate for data replication and integration. It is intended for DBAs, developers, and technologists responsible for data replication and high availability. The course covers Oracle GoldenGate concepts, installation, architecture, configuration, DML and DDL replication, security, troubleshooting, and performance monitoring. Hands-on labs use Oracle 12c databases on Linux to demonstrate GoldenGate concepts. Upon completion, participants will have knowledge to work on GoldenGate projects.

    Original Title

    GoldenGateCourse+Agenda

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This 19-20 hour course teaches Oracle GoldenGate for data replication and integration. It is intended for DBAs, developers, and technologists responsible for data replication and high availability. The course covers Oracle GoldenGate concepts, installation, architecture, configuration, DML and DDL replication, security, troubleshooting, and performance monitoring. Hands-on labs use Oracle 12c databases on Linux to demonstrate GoldenGate concepts. Upon completion, participants will have knowledge to work on GoldenGate projects.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    37 views3 pages

    GoldenGateCourse Agenda

    Uploaded by

    Mohammad Mazheruddin
    This 19-20 hour course teaches Oracle GoldenGate for data replication and integration. It is intended for DBAs, developers, and technologists responsible for data replication and high availability. The course covers Oracle GoldenGate concepts, installation, architecture, configuration, DML and DDL replication, security, troubleshooting, and performance monitoring. Hands-on labs use Oracle 12c databases on Linux to demonstrate GoldenGate concepts. Upon completion, participants will have knowledge to work on GoldenGate projects.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    Course: Oracle GoldenGate

    Duration: 19-20 hours hours

    Who Should Attend: DBAs, PL/SQL Developers, Technologists responsible for data replication,

    High availability technologists.

    Salient Features:

    Implementation and configuration of the Oracle Golden Gate replication \

    Objective:

    The objective of this training is to explain the fundamental concepts of Oracle GoldenGate used
    for data replication and integration. At the end of this training, the participants are expected to
    have Goldegate knowledge and will be able to start working on live projects.

    Environment:

    Version: Oracle 12c GoldenGate

    Platform: UNIX / Any flavor of Linux supported by Oracle 11.x.x.x GoldenGate/12c

    Database: Oracle 12.1.2.0.1 multitenant Architecture

    a) Oracle 12c Database server

    b) Two instances of Oracle GoldenGate

    Hands on:

    Oracle GoldenGate concepts will be explained by demonstration programs wherever required


    on Oracle Database running on Linux/Windows Platform.

    Ashish Agarwal
    Course Contents:

    1) Overview of Oracle Database


     Architecture
    2) Introduction to Oracle Golden Gate
     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
    3) Installing Oracle Golden Gate
     Downloading the software from Oracle website.
     Installing Oracle Golden Gate
     Explaining Subdirectories
     Preparing Oracle 12c database for data replication
    4) Oracle Goldengate Architecture
     Concepts and Components
     Process Data Flow
     Design Considerations
    5) Configuring & Preparing the Environment-
     Configuring the Manager process
     Describing the Manager Parameters
     Starting the Manager process
     Configuring GLOBALS file
    6) DML Replication - Online Change Synchronization
     Description and Demo
     Integrated Extract vs Classic Extract
     Integrated Replicat vs Classic Classic Replicat
    7) Initial Load
     Getting two databases into sync initially
    8) Zero Downtime Migration and Upgradation using Goldengate
     Strategy
    9) Goldengate 12c new features
    10) Parameter files
     Parameters
     How to Comprehend Parameter File
     How to configure Parameter File
    11) Data Definitions File
     Overview of Data Definitions File
     When to use Data Definitions Files

    Ashish Agarwal
     Types of Data Definitions File
     Configuring Data Definitions File
    12) DDL Replication
     Alter, Drop, Create Overview of DDL synchronization
     Configuring Extract and Replicat for DDL replication
    13) Bidirectional Replication
     CDR(Conflict detection and Resolution)
     Active Active
     Active Passive
    14) Oracle Goldengate Security
     Wallet Creation
     Password Encryption
    15) Troubleshoot Goldengate Issues
     Discard File Creation
     Add a new table in already running goldengate config
     Adjusting the extract and replicat based on SCN/DB logs/Timestamp

    16) Managing Oracle Golden Gate


     Managing trail files
     Automating process startup
     Using reporting and statistics
    17) Reading trail files
     Logdump Utility
    2. Performance of Oracle Goldengate
     How to monitor Goldengate
     Monitor lag

    Q And A session

    Along, with this training Virtual Machine setup along with Linux image loaded with Oracle Database and
    oracle Goldengate will be shared.

    We will be sharing documentations, test cases and interview questions as well with this training. Also,
    will help student ins etting up their own lab on their machine.

    Certification:

    Oracle Goldengate Implementation Specialist

    Oracle Goldengate 12c Essentials

    Ashish Agarwal

    You might also like