Golden Gate Training
Oracle Goldengate contains 3 parts
1. Oracle Goldengate Classic Architecture
2. Oracle Goldengate Microservices Architecture
3. Oracle Goldengate Veridata
Oracle Goldengate Classic Architecture is traditional architecture and is mandatory to learn Goldengate. It is command prompt based architecture – GGSCi based. Duration of this course is 19-24 hours.
Oracle Goldengate Microservices architecture is new architecture launched in 2017. its GUI based architecture and allows better integration with Cloud applications. its future of Goldengate. Duration of this course is 11-14 hours. Advanced level course.
Oracle Goldengate Veridata is data validation tool which validates the data between source and target. Also Goldengate certification contains questions from veridata as well. Duration of this course is 10-12 hours. Advanced level course.
Oracle GoldenGate (Classic Architecture)
Duration: 19-24 hours Who Should Attend:
• Data Warehouse Administrator • Data Warehouse Analyst • Data Warehouse Developer • Database Administrators • Database Designers • System Integrator • Technical Consultant
.
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:
Platform:
UNIX / Any flavor of Linux supported by Oracle 11.x.x.x GoldenGate/12c
Database:
Oracle 12.2.0.0.1 multitenant Architecture
a) Oracle 12c Database server
b) Two instances of Oracle GoldenGate
Course Contents:
1) Overview and Introduction of Oracle Database
• Architecture
• 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) Types of Oracle Goldengate Architecture
• Classic Architecture
• Microservices Architecture
• Types of Extracts and Replicats
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
• Integrated Replicat
• Parallel Replicat (Integrated and Classic)
7) Initial Load
• Getting two databases into sync initially
• Direct Load and File to Replicat
8) Zero Downtime Migration and Upgradation using Goldengate
• Strategy
9) Goldengate 19c new features
• Remote Capture cross endian support
10) Upgradation of Goldengate from 12c to 19c
11) Parameter files
• Parameters
• How to handle collisions using HANDLECOLLISIONS
• How to Comprehend Parameter File
• How to configure Parameter File
13) DDL Replication
• Alter, Drop, Create Overview of DDL synchronization
• Configuring Extract and Replicat for DDL replication
14) Bidirectional Replication
• CDR(Conflict detection and Resolution) new feature
• Active Active
• Active Passive
15) Oracle Goldengate Security
• Wallet Creation
• Password Encryption
16) 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
17) Managing Oracle Golden Gate
• Managing trail files
• Automating process startup
• Using reporting and statistics
18) Reading trail files
• Logdump Utility
• How to read trail file
• How to resolve issues
19) Performance of Oracle Goldengate
• How to monitor Goldengate
• Monitor lag
• Goldengate Heartbeat table
• PMSRVR
• Heartbeat Table
• Oracle Goldengate Checkpoint
• Describing Oracle Goldengate CSN
Course: Oracle GoldenGate Microservices
Duration: 10-12 hours
Who Should Attend:
DBAs, PL/SQL Developers, Oracle Goldengate Admin, Technologists responsible for data replication, High availability technologists. Solution Architects, Data Architects
Salient Features:
Implementation and configuration of the Oracle Golden Gate Microservices
Objective:
The objective of this training is to explain the fundamental concepts of Oracle GoldenGate Microservices used for configuring and setup Goldengate replication.
Environment:
Version: Oracle 12c/18c/19c GoldenGate Microservices Platform: Any flavor of Linux/ GoldenGate 12c/18c/19c Database: Oracle 12.1.2.0.1/18c multitenant Architecture
a) Oracle 12c/18c Database server
b) Two instances of Oracle GoldenGate Microservices
Course Contents:
Module 1: Overview and Introduction to Goldengate Microservices.
Module 2 – Download and Installation of MSA
Module 3 – Create Service Manager and Deployment/s
Module 4 – Add credentials in credential Store
Module 5 – Configuration of GG MSA
Module 6 – Add Goldengate Extracts, Replicats and Distribution Server
Module 7 – Bounded Recovery concept in Goldengate
Module 8 – What are parameters and Configuration of Parameter Files in GoldenGate MSA
Module 9 – How to recover/reset password of Service Manager
Module 10 – Comparison of new Goldengate MSA architecture with existing Classic/Integrated Architecture
Module 11 – Initial Load in GG Moicroservices – File to Replicat
Module 12 – Performance Metrics (Monitoring Performance) of Goldengate MSA
Module 13 – Admin Client in Microservices vs GGSCI in Classic Architecture
Module 14 – How to read trail files in MSA (Usage of logdump)
Module 15 – DDL Replication in OGG MSA
Module 16 – Bidirectional Replication and Bidirectional Auto CDR setup in OGG MSA
Module 17 – Directory structure comparison between OGG Classic and OGG MSA
Module 18 – Classic architecture to MSA replication (Source has classic architecture and target has Microservices architecture)
Module 19 – MSA to Classic architecture replication (Source has MSA architecture and target has Classic architecture)
Module 20 – How to upgrade oracle Goldengate Microservices
Module 21 –Troubleshooting issues in Goldengate MSA
Module 22 – Deinstallation of Oracle Goldengate Microservices
Course: Oracle GoldenGate Veridata
Duration: 10-12 hours
Who Should Attend:
DBAs, PL/SQL Developers, Oracle Goldengate Admin, Technologists responsible for data replication, High availability technologists.
Salient Features:
Implementation and configuration of the Oracle Golden Gate Veridata
Objective:
The objective of this training is to explain the fundamental concepts of Oracle GoldenGate Veridata used for comparing and verifying data. At the end of this training, the participants are expected to have Veridata knowledge and will be able to start working on live projects.
Environment:
Version: Oracle 12c GoldenGate Veridata
Platform: UNIX / Any flavor of LinuxGoldenGate/12c
Database: Oracle 12.1.2.0.1 multitenant Architecture
a) Oracle 12c Database server
b) Two instances of Oracle GoldenGate
What Is Oracle Goldengate Veridata:
➢ Oracle GoldenGate Veridata compares one set of data to another and identifies data that is out of synchronization.
➢ Oracle GoldenGate Veridata supports high-volume, 24×7 replication environments where downtime to compare data sets is not an option.
➢ By accounting for data that is being replicated while a comparison takes place, Oracle GoldenGate Veridata can run concurrently with data transactions and replication, while still producing an accurate comparison report. ➢ Oracle GoldenGate Veridata will map column data types across different types of databases automatically, or you can map columns manually in cases where the automatic mapping is not sufficient to accommodate format differences in a heterogeneous environment.
Course Contents:
Module 1: Veridata Download Software – Download the software – Download JDK
Module 2: Veridata Installation – Installation of JDK – Veridata Server Installation – Weblogic Installation
Module 3: Veridata Configuration – Creating weblogic user – Configure the Veridata Repository Schema(RCU) – Configure Domain for Veridata
Module 4: Deploy Agents – Deploying agents on target servers – Starting weblogic server – Verify the agent connection
– Starting managed server
Module 5: DataSource Connection – Veridata administrator User and roles – Creating connection to databases – Testing and verifying the database connection
Module 6: Setting up Veridata Compare Pairs – Setting up Groups – Setting up Compare Pairs – Configuring and running Jobs – Troubleshooting issues – Identifying and Repairing the discrepancies
Module 7: Tuning and Performance of Veridata – Tuning parameters – Improving Veridata Performance – Setting up pofile