The course is designed to get in-depth basic knowledge which will help in pratical in real time.
Demo video session also available
Many real-time scenario are covered.
Below is the course outline
Course Outline/Agenda:
Introduction to Oracle Golden Gate
Oracle Golden Gate Technology and Architecture
Configuring & Preparing the Environment
GoldenGate Directory Structure
GoldenGate Checkpoint
Configuring Change Capture Delivery
Oracle Golden Gate Commands
Managing Oracle Golden Gate
Golden Gate TroubleShooting
Real Time Scenarios Description
Practical Focused Topics:
1. Supplemental Logging
2. Integrated Extract and Replicate Setup
3. Parameter handling and working
4. Handlecollison practical
5. Troubleshooting methods
6. Practical importance of dirchk/dirpcs/dirrpt/dirout and other files
7. Classic Extract and Replicate Setup
8. Drive into MGR parameters
9. Integrated Extract with Classic Replicate
10. DDL replication
11. Setting up process among various GG versions (12.2 and 11g)
12. Use of Defgen file
13. Initial load using Datapump
14. Initial Load using Golden Gate Method
15. Adding a table in existing Extract/replicate setup
16. To resync few tables in existing set of tables to solve data issue
17. OOG-01519 Replicate Stuck issue
18. Steps to split Tables among on-going running replicate
19. Steps to split Table among on-going running Extract
20. Guidelines for long running session to be taken care before stopping Extract
21. In case of corrupted and loss of local trails how to start replicate with min data loss when re-sync is not an option
22. Re-extracting Pump in case of target trail corruption when checkpoint table available
23. Re-extracting Pump in case of target trail corruption when no checkpoint table available
24. Use case to troubleshoot stuck OGG process
25. Golden Gate upgrade