Course Overview
Introduction
- Uses of Oracle GoldenGate
- Reviewing Oracle GoldenGate Use Cases
- Oracle GoldenGate Use-Cases for Oracle Database
- Technology Overview
- Topologies
- Supported Platforms
- Supported Databases
- Oracle GoldenGate Technology Suite
Oracle GoldenGate Architecture
- The Two Oracle GoldenGate Architectures
- Classic Architecture
- Extracts
- Initial Loads
- Checkpoints
- The Interaction Between Oracle GoldenGate and Oracle RDBMS
Installing Oracle GoldenGate
- Listing System Requirements
- Performing Installation
- Configuring Environment Variables
- Using Oracle GoldenGate Software Command Interface (GGSCI)
- Running Oracle GoldenGate from the OS shell.
- Use Obey files to automate tasks
Preparing the Environment and Configuring Integrated Extract
- Configuration Overview
- Preparing the Environment
- Enabling Oracle GoldenGate in the Database
- Enabling Supplemental Logging
- Defining Roles and Permissions
- Starting the Manager
- Configuring Data Capture
Configuring Initial Load
- Initial Load Overview
- Configuring Initial Load
- Setting Up the Initial Load by Using the “File to Replicat” Method
- Setting Up the Initial Data Load by Using the “Direct Load” Method
Configuring Change Delivery (Replicat)
- Replicat Overview
- Configuring Replicat Tasks
- Adding Checkpoints
- Using Checkpoints
- Initial Load: Avoiding Collisions with Initial Load
- Initial Load: Handling Collisions with Initial Load
- Troubleshooting: GGSCI Process Information
- Troubleshooting: Report FIles and Log FIles
Managing Extract Trails and Files
- Trail Format: Local and Remote
- Trail Format: Cleanup
- Trail Format: Record Header Area
- Trail Format: Record Data Area
- Alternative Trail Formats: Logical Change Records (LCRs)
- Alternative Trail Formats: Text, SQL, and XML
- logdump: Opening, Viewing, and Filtering
Oracle GoldenGate Parameters
- GLOBALS
- Manager
- Source Manager Parameters
- Target Manager Parameters
- Extract
- Extract Parameters on the Source Database
- Replicat
- Options Common to Both Replicat and Extract
Data Selection and Filtering
- Mapping and Manipulation
- Definition Files
- Data Selection
- Where
- Filter
- Mapping
- SQLEXEC
Additional Transformation and Configuration Options
- Create and Invoke Macros
- Set and Retrieve Useer Tokens
- Run User Exits in GoldenGate Processes
- Compress Data Across the Network
- Encrypt Messages, Trails, and Passwords
- Automatically Trigger Actions Based on Event Records
Installing Oracle GoldenGate Microservices Architecture
- Identify and Describe the Various Components of the Oracle GoldenGate Microservices Architecture
- List the Operating System Pre-Requisites Needed for a Microservices Architecture installation
- Perform an Oracle GoldenGate Microservice Architecture Installation and Verify its Successful Completion
Oracle GoldenGate Microservices Architecture - Administration Server
- Using the Administration Server Embedded Web Application to Create Extract and Replicat Groups
- Accessing Extract/Replicat Process Parameters, Statistics, Checkpoints and Reports Using the Administration Server Embedded Web Application
Oracle GoldenGate Microservices Architecture – Distribution Server
- Using the Distribution Server Embedded Web Application to Create, Start and Stop Paths
- Accessing the Data Path Parameters, Statistics, SCN / RBA Positions in Trail Files, and Data Filters Using the Distribution Server Embedded Web Application
Oracle GoldenGate Microservices Architecture - Receiver Server and Performance Metrics Server
- The Role and Functionality of an MA Receiver Server
- The Role and Functionality of an MA Performance Metrics Server
MA Admin Client
- Using the Admin Client to Connect to an MA Deployment
- Performing Common Administrative Tasks by Using the Admin Client
- Database Sharding Support, Metadata Encapsulation, Replication Lag Management, Invisible Column Support
Database Sharding Concepts and GoldenGate MA Support for It
- Metadata Encapsulation Features and Advantages
- Implementing a Lag Management Policy
- Handling Replication of Invisible Columns