Online Oracle Goldengate Training Classes And Courses  BISP 

60% Complete Courses » Oracle Goldengate
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


INTRODUCTION TO ORACLE GOLDENGATE
  • History of Oracle GoldenGate
  • Databases supported by Oracle GoldenGate
  • Oracle GoldenGate related products(Veridata, monitor, Director, OEM plugin

ORACLE GOLDENGATE ARCHITECTURE
  • Modular and Logical Architecture
  • Commit Sequence Number

INSTALLING ORACLE GOLDENGATE
  • Preparing environment for Oracle GoldenGate(Download windows and Linux builds and install DB on laptop)
  • Installing Oracle GoldenGate 11g on windows and Linux
  • Installing Oracle GoldenGate 12c using Graphical Environment
  • Installing Oracle GoldenGate 12c using Silent Mode
  • Applying patches for Oracle GoldenGate 11g
  • Applying patches for Oracle GoldenGate 12c
  • Upgrade from Oracle GoldenGate 11g to 12c

INITIAL LOAD
  • Different Types of Initial Load
  • Considerations before Doing Oracle GoldenGate Initial Load
  • Configuring Direct Initial load
  • Configuring File To Replicate Method
  • Recommended Methods for Initial Load Outside of Oracle GoldenGate

ONLINE CHANGE SYNCHRONIZATION
  • Prerequisites
  • Configuring Change Capture Without Data Pump
  • Configuring Change Capture With Data Pump
  • Using Source Definitions file
  • Configuring GLOBALS file

DDL and SEQUENCE Replication
  • Trigger Based DDL Replication
  • Native DDL Replication (Triggerless)
  • Sequence Replication
  • DDL INCLUDE/EXCLUDE parameters

TYPES OF EXTRACT AND REPLICATE

  • Overview on type of Extracts
  • Overview on type of Replicate
  • Configuring Classic Extract
  • Configuring Integrated Extract
  • Configuring Classic Replicate
  • Configuring Integrated Replicate
  • Configuring Coordinated Replicate

MANAGING ORACLE GOLDENGATE
  • GGSCI Commands
  • Native Commands
  • GLOBALS parameters
  • Oracle GoldenGate parameters
  • Collector Parameters
  • Column Conversion Functions
  • Using Obey Files
  • Macros and Stored Procedures
  • Filtering and Manipulation
USING LOGDUMP UTILITY

IMPLEMENTING SECURITY ON ORACLE GOLDENGATE
  • Password Encryption
  • Trail File Encyrption
TROUBLESHOOTING ORACLE GOLDENGATE
  • What to check for Extract Issues?
  • What to check for Replicat Issues?
  • Data Issue
  • Performance Issues of Extract
  • Performance Issues of Replicat
NEW FEATURES IN ORACLE GOLDENGATE 12.2
  • Self Describing Trail Files
  • Automatic Heartbeat Table
  • Automatic Trail File Recovery
  • Trail File 9 Digit Sequence
BIDIRECTIONAL REPLICATION (ACTIVE-ACTIVE)
  • Considerations for ACTIVE-ACTIVE
  • Managing Conflicts
  • Conflict Detection and Resolution

USE-CASES OF ORACLE GOLDENGATE
  • Add a new Table in Existing Replication
  • Disaster Recovery (Active-Passive)
  • Zero Downtime Upgrade and Migrations
  • ALO Mode

Course Id:
ODI002 
Course Fees:
301 USD