Premium Quality
1 Year Unlimited Access
100% Satisfaction Guarantee
The most comprehensive, all-in-one and up-to-date course
Includes both Classic Architecture as well as Microservices Architecture
Concept lectures and hands-on demonstrations
Downloadable Resources: Slides, Activity Guide
1 year 24/7 access to course recordings
Latest and up-to-date content
Free Access to Course Updates
Secure Payments: Online using Credit/Debit Cards, PayPal, Net Banking, UPI
Support for doubts
Phone call, WhatsApp, Email Support
Direct contact with Course Instructor via Phone Call, WhatsApp for any doubts
Free Membership in Course Community
Certificate of Attendance
Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.
Oracle GoldenGate 19c Administration is the most comprehensive and all-in-one course that teaches you both Classic Architecture and the newly introduced Microservices Architecture.
You will gain a strong foundation and expertise in implementing Oracle GoldenGate solutions. The course will deep dive into Oracle GoldenGate architecture, parameters, mapping, transformations, and much more with real-time examples.
You will learn to:
Install, Configure and manage Oracle GoldenGate
Implement Initial Load
Implement Online Change Synchronization
Implement Unidirectional and Bidirectional Replication
Perform Data Mappings and Manipulations
Monitor Oracle GoldenGate Processing
Implement DDL Replication
Setup Oracle to PostgreSQL Replication
Microservices Architecture
Install Microservices Architecture
Implement Replication using Microservices Architecture
Introduction to Oracle GoldenGate
What is Oracle GoldenGate?
Why do you need Oracle GoldenGate?
When do you use Oracle GoldenGate?
Topologies for Oracle GoldenGate
Supported Databases
Supported Operating Systems
GoldenGate Vs Data Guard
Oracle GoldenGate Product Family
Oracle GoldenGate Architecture
Classic Architecture and Microservices Architecture (MA)
When to use which Architectures?
Components of Oracle GoldenGate Classic Architecture
Manager, Extract, Data Pump, Collector, Replicat
Extract Trail, Remote Trail, Checkpoints, Wallet, GGSCI
Parameter Files – GLOBALS file, runtime parameter files
Processing Types – online, source-is-table, special-run, remote process
Processing Groups
Commit Sequence Number (CSN)
Types of Extracts - Classic Extract and Integrated Extract
Types of Replicats - Classic, Integrated, Coordinated and Parallel Replicats
Installing Oracle GoldenGate
Preparing the Practice Environment
Downloading the software
Installing and configuring Oracle GoldenGate software
Preparing the Database for Oracle GoldenGate
Establishing GoldenGate Credentials
Enabling GoldenGate in Oracle Databases
Configuring Database Logging Options - Archive Log, Force Log, Supplemental logging
Securing GoldenGate Credentials
Creating Credential Store
Adding Credentials to Credential Store
Using Secured Credentials in Parameter Files
Configuring Online Change Synchronization (Unidirectional)
Overview of Online Change Synchronization
Choosing Names for Processes and Files
Creating Online Extract Group
Creating a Trial
Creating Parameter File for Online Extraction
Creating an Online Replicat Group
Creating a Parameter File for Online Replication
Configuring Initial Change Synchronization (Initial Load)
Overview of Initial Load Procedure
Initial Load in Classic Architecture
Prerequisites for Initial Load
Performing Initial Load
Monitoring Oracle GoldenGate Processing
Using the Information Command in GGSCI
Monitoring Extract Recovery
Monitoring Lag
Monitoring Processing Volume
Using the Error Log
Using the Process Report
Using the Discard File
Maintaining Discard and Report Files
Mapping and Manipulating Data
Parameters that control Mapping and Data Integration
Mapping Columns using TABLE and MAP
Selecting and Filtering Rows
Retrieving Before and After Values
Selecting Columns
Testing and Transforming Data
Using Tokens
Implementing DDL Replication
Requirements and Restrictions
DDL Replication Scope
Setup DDL Replication
Control behavior of DDL Replication
Handling Errors
Configuring Oracle GoldenGate for Active-Active, Bidirectional Replication
Overview of an Active-Active Configuration
Considerations for Active-Active Configuration
Preventing Data Looping
Managing Conflicts
Configuring Conflict Detection and Resolution (CDR)
Configuring Manual CDR
Configuring Auto CDR
Oracle GoldenGate Microservices Architecture
Oracle GoldenGate Microservices Architecture (MA)
Classic Vs Microservices Architecture
Access Points for Microservices
Components of Microservices Architecture
Service Manager
Administration Service
Distribution Service
Receiver Service
Performance Metrics Service
Deployments
What is Deployment?
Secure Deployment
Non-Secure Deployment
Local Deployment
Remote Deployment
Installation of Oracle GoldenGate Microservices
Preparing the Practice Environment
Downloading Oracle GoldenGate Microservices Software
Installing the Software
Adding a Deployment
Understanding GoldenGate MA Software Installation
Installation Directories
Top Level Directories
Software Home Directory and Files
Service Manager Home Directory and Files
Deployment Home Directory and Files
GoldenGate Daemon
Configuring Databases and GoldenGate for Replication
Enabling Force Logging
Enabling Supplemental Logging
Configuring Archive Log mode
Establishing GoldenGate Credentials
Enabling GoldenGate in Database
Configuring Oracle Net Service Names
Configuring Online Change Synchronization
Overview of Online Change Synchronization
Processing Groups and Naming Convention
Adding Extract
Adding Replicat
Adding Distribution Path
Testing Change Synchronization
Configuring Initial Change Synchronization
What is Initial Load?
Prerequisites for Initial Load
Implementing Initial Load
Adding Initial Load Extract
Adding Replicat
Adding Distribution Path
Using Admin client
Becoming Familiar with Admin Client
Using Admin Client
.