GoldenGate Online Training
Oracle GoldenGate Online Training
GoldenGate Online Training Course Content :
Introduction to Oracle Golden Gate
- Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability.
- Supported databases and platforms
- Advantages of Oracle Golden Gate
Installing Oracle Golden Gate
- Downloading the software from Oracle website.
- Installing Oracle Golden Gate
- Explaining Subdirectories
- Preparing Oracle 11g database for data replication
Oracle Golden Gate Technology and Architecture
- Understanding Golden Gate Components: Processes and Files
- Process Data Flow
- GoldenGate Architecture
- Design Considerations
Configuring & Preparing the Environment
- Configuring the Manager process
- Describing the Manager Parameters
- Starting the Manager process
- Configuring GLOBALS file
Data Definitions File
- Overview of Data Definitions File
- When to use Data Definitions Files
- Types of Data Definitions File
- Configuring Data Definitions File
Configuring Change Capture Delivery – With and Without Data Pump
- Preparing a source database for transaction capture
- Describing the high-level configuration steps
- Explaining change capture and delivery with a data pump
- Explaining change capture and delivery without a data pump
- Comparing batch and online operation
- Explaining Oracle Golden Gate Checkpoints
- Describing the Extract process
- Configuring and starting an Extract process
- Adding local and remote trails
- Configuring and starting a data pump
- Explaining the Replicate process
- Configuring a Replicate process
- Starting a Replicate process
- Describing GGSCI commands
- Describing Extract trails and files
Configuring Change Capture Delivery – DDL Replication and Initial Data Load
- Overview of DDL synchronization
- Preparing a source database for transaction capture
- Describing the high-level configuration steps
- Configuring Extract and Replicat for DDL replication
- Configuring Initial Data Load using Oracle GoldenGate Extract and Replicat
Oracle Golden Gate Commands
- Running Golden Gate commands from the GGSCI prompt
- Running Golden Gate commands from the obey files
- Running Golden Gate commands from the OS shell
- dentifying the types of GGSCI commands available
Managing Oracle Golden Gate
- Managing trail files
- Automating process startup
- Using reporting and statistics
GoldenGate Security Features
- Using message, trail and password encryption
- Controlling command permissions – CMDSEC file
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
- Using built-in functions
- Using SQLEXEC to interact directly with a database
Troubleshooting Oracle Golden Gate
- Troubleshooting process startup failures
- Troubleshooting slow startup
- Troubleshooting Extract problems
- Troubleshooting missed transactions
- Using the discard file
- Using SHOWSYNTAX to view Replicat SQL statements
- Using the Logdump utility
GoldenGate Performance Tuning
- Using BATCHSQL to speed delivery
- Using RANGE Function
- Using parallel Replicat groups on a target system
Drop your query
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
