Brochure
Enquire
- 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
- Home
- Mindmajix Technologies
- Courses
- Oracle GoldenGate Training
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
The syllabus
Introduction
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)
- 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
Goldengate – Bidirectional
- Pictorial view
- Configurations
- Data looping’s
- Resolving conflicts
- Effect of Oracle Sequences
Advanced Configuration: Mapping And Manipulating Data
- Overview of data mapping and manipulation
- Deciding where data mapping and conversion will take place Data Selection and Filtering
- Data Transformation
Articles
Popular Articles
prev
next
