Oracle GoldenGate 19c
Course Duration: 30 Hours
Required Prerequisites
- Good Knowledge of Oracle DBA
Target Audience
- Oracle DBA who wants to learn Oracle GoldenGate
Students Enquiry Form
Course Highlights
- GoldenGate Architecture
- Setting of up linux server and installation of Oracle DB
- Install GoldenGate
- Oracle to Oracle configuration basics
- Extract data
- Replicate data
- Trail Files
- Initial load
- Data and configurations
- Macros and Tokens
- Bi-Directional Replication Configuration
- DDL Replication
- Microservice Architecture
Course Content
Section 1: Goldengate Architecture
- GG Components
- Architecture Basics
- Processes
- Parameters
- Topologies
- Role Of Datapump In GG
- Integrated Extract
- Data Load
Section 2: Setting Of Up Linux Server And Installation Of Oracle DB
- Install Oracle Enterprise Linux Servers
- Install Oracle Database Software
- Setup Goldengate OS Add-On
- Clone Linux Servers
- Configure Oracle Databases
- Goldengate Use Cases
Section 3: Install GoldenGate
- Supported DB’s
- OS Combinations
- Software And OS Requirements
- Installation – OUI
- Directories
Section 4: Oracle To Oracle Configuration Basics
- Steps To Configure
- Preparing Environment – Character Set
- Configure User – Oracle Database
- Network Diagnostics
- Preparing Environment – Supplemental Logging
- Configuring Manager
Section 5: Extract Data
- Change Capture
- Datapump Options
- Process Groups
- Configure Wallet
- Integrated Capture
- Extract Trails
- Start Extract
Section 6: Replicate Data
- Change Delivery Basics
- CDD Activities
- Treat Collisions
- Integrated Apply
- Monitoring
- Reports & Diagnostics
Section 7: Monitoring GoldenGate
- What is GGSCI ?
- Various GGSCI Command to Monitor Extract , Pump and Replicate Process
- Monitor Lag and Statistics
Section 8 : Trail Files
- Extract Trails And Files
- Formats
- Substitutes
- Logdump
- Logging Trails
- Reverse Utility
Section 9: Replication With Initial Load
- Initial Load
- Kick Start Load
- Pre-Checks
- Methods
- File Based Loading
- Direct Load
Section 10: Data And Configurations
- GLOBAL & Manager Parameters
- Extract & Replicat Parameters
- Data Selection: WHERE, FILTER
- Data Mapping: Columns
- RANGE
- SQLEXEC Functionalities
- Functions Specific To Goldengate
Section 11: Other Considerations In GG
- Macros & Tokens
- User Exits & Sequences
- Batchsql In GG
- Data Compression In GG
- Daa Encryption & Events
Section 12: Bi-Directional Replication Configuration ( Active – Active )
- Configurations
- Data Loopings
- CDR ( Conflict Detection And Resolution )
Section 13: DDL Replication
- About DDL Replication
- Things to consider before configuring DDL Replication
- Configuring DDL Replication
- Configure “Sequence Number” Replication
Section 14: GoldenGate New Features
- GoldenGate Microservice Architecture
- Format Release parameter
- Trail File Difference
- Automatic Heartbeat Table
- Improved Trail File Recovery
- Credential Store and Useridalias
- Parallel Replicate
- Auto-CDR
- Procedural Replication to Enable simpler migrations and upgrades
- Cross Endian Support For Remote Integrated Extract
- Enhanced the Heartbeat table to Include details for restarting extract