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