Oracle Goldengate 19c – Learn and Master Oracle Goldengate

Professionally learn to design & implement Goldengate setup for ur customer & enterprise

Created by: Ashish Agarwal
Oracle Goldengate Specialist and Database Analyst

What Will I Learn?

• Latest and Master Oracle Goldengate Version 19c with practicals and realtime activites
• Install and Download Oracle GoldenGate 19c in realtime - Decide where to Install oracle Goldengate
• Issue GGSCI commands.
• What are the different architectures of Goldengate and how to setup Replication
• Realtime Activities to setup Oracle Goldengate processes
• Configure, start, stop and monitor Change Capture and Delivery processes in Realtime
• Manage Extract trails, Remote trails and files using Data Pump and Replicat
• How to design and analyse Oracle Goldengate for your projects - Things to consider and how to do seggregation
• Prerequisites to download and setup Oracle Goldengate 19c
• How to check Oracle Goldengate Certification matrix
• Comprehend and Create Goldengate process parameter files
• Different types of extracts and Replicats available for configuration in 19c
• Oracle Goldengate how to perform Silent Installation
• Setting up Oracle database and preparing source and target database for Goldengate Replication
• Oracle Goldengate 19c New features
• Oracle Goldengate 19c: Troubleshooting - OGG common issues troubleshooting,approach and strategy
• Oracle Goldengate 19c: Tuning - Perform tuning of Manager, Extract and Replicate.
• Identify what causes slow startups.
• Monitor lag and statistics.
• Oracle Goldengate Bidirectional Replication- Setup in realtime with considreations and things to keep in mind
• Bidirectional Auto CDR - Oracle Goldengate new feature-
• Diagnose and tune the Integrated Extract and Integrated Replicat and usage and benefits
• Parallel Replicat - Oracle Goldengate new feature setup in realtime and usage and benefits
• Heartbeat Table - Oracle Goldengate new feature setup in realtime and usage and benefits
• Performane Matrix server(PMSRVR)- Oracle Goldengate new feature setup in realtime and usage and benefits
• DDl Replication setup in realtime and usage and benefits
• What is Supplemental logging - benefits and usage
• Create Oracle Goldengate Credential Store
• Goldengate architecture and Process data flow
• Difference between Time since Checkpoint and Lag at Checkpoint
• Goldengate process status and trail file switchover scenarios
• How to autostart Goldengate processes realtime
• Oracle Goldengate concepts and components
• Oracle Goldengate Initial Load and File to Replicat initial load in realtime
• Zero downtime upgradation and migration Strategy
• Realtime usage and benefits to show how GG could be used as business intelligence tool along with informatica/ODI
• Data Filteration and transformation
• How to add new table into already running OGG configuration
• Oracle Goldengatesecurity in realtime and how to perform trail file Encryption
• How to read Goldengate trail files using Logdump utility in realtime
• How to put description to Oracle Gldengate new and existing processes
• Oracle Goldengate Macros,Obey Files and Include Files
• Special sessions on project activites, how to HANDLE Collisions and different parameters
• Enabling Command Line security

Requirements

• Basic knowledge of database architecture
• Familiarity with Linux Basics
• Familiarity with SQl Basics

Target audience

• Administrator
• Database Administrator
• Implementer
• System Integrator
• Systems Administrator
• Analyst
• Architect
• Developer
• DBAs
• Goldengate Administrators
• technologists