Person who will have to work with different databases in the enterprise like DBA.
Oracle GoldenGate is a tool, Developed to work with the heterogeneous databases.
Sound knowledge of database or DBA's
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Live Interactive classes with expert
Oracle Golden Gate Topic Overview:
Introduction to Oracle Golden Gate
Oracle Golden Gate Technology and Architecture
Installation of Oracle Golden Gate
Configuring & Preparing the Environment
Configuration of Oracle Golden Gate Process → Classic/Integrated
GoldenGate Directory Structure
Golden Gate Troubleshooting methods
Oracle Golden Gate Commands
Stroll over guidelines
Degen file/Credential Store
Real Time Scenarios :
Integrated Extract and Replicate Setup
Parameter handling and working
Classic Extract and Replicate Setup
Drive into MGR parameters
Integrated Extract with Classic Replicate
To handle deletion of Trail file outside OGG with checkpoint table
To handle deletion of Trail file outside OGG incase checkpoint table not available
Setting up process among various GG versions (12.2 and 11g)
Use of Defgen file and Credential Store
Initial load using Datapump
Initial Load using Golden Gate Method
Adding a table in existing Extract/replicate setup
To resync few tables in an existing set of tables to solve data issue with downtime
To resync few tables in an existing set of tables to solve data issue without downtime
OOG-01519 Replicate Stuck issue rollover
Steps to split Tables among on-going running replicate
Steps to split Table among on-going running Extract
Guidelines for the long running session to be taken care before stopping Extract
In case of corrupted and loss of local trails how to start to replicate with min data loss when re-sync is not an option
Re-extracting Pump in case of target trail corruption when checkpoint table available
Re-extracting Pump in case of target trail corruption when no checkpoint table available
Use case to troubleshoot stuck OGG process
Golden Gate upgrade/migration
"No Resources for this Course"
Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.
We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.