• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

This training program is designed to prepare the students for Oracle GoldenGate 11g Developer track. The Oracle GoldenGate 11g: Fundamentals for Oracle course focuses on Oracle-to-Oracle data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances


Duration : 30 hours


Fee: 319


Job Trends


Who Should Learn?

Person who will have to work with different databases in the enterprise like DBA.

Prerequisite

Oracle GoldenGate is a tool, Developed to work with the heterogeneous databases.

Sound knowledge of database or DBA's

Delivery Methodology

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.

Class Delivery

Live Interactive classes with expert

Training Calender

Date Time Type Attend
22nd October 2019 7:00 AM   IST Regular
19th October 2019 7:00 AM   IST Demo
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Oracle Goldengate

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
Supplemental Logging 
Configuration of Oracle Golden Gate Process → Classic/Integrated
Initial Load
GoldenGate Directory Structure
Golden Gate Troubleshooting methods
GoldenGate Checkpoint
Oracle Golden Gate Commands
Stroll over guidelines 
DDL replication
Degen file/Credential Store

Real Time Scenarios :
 

  1. Integrated Extract and Replicate Setup

  2. Parameter handling and working

  3. Handlecollison practical

  4. Troubleshooting methods

  5. Classic Extract and Replicate Setup

  6. Drive into MGR parameters

  7. Integrated Extract with Classic Replicate

  8. To handle deletion of Trail file outside OGG with checkpoint table

  9. To handle deletion of Trail file outside OGG incase checkpoint table not available

  10. DDL replication

  11. Setting up process among various GG versions (12.2 and 11g)

  12. Use of Defgen file and Credential Store

  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 an existing set of tables to solve data issue with downtime

  17. To resync few tables in an existing set of tables to solve data issue without downtime

  18. OOG-01519 Replicate Stuck issue rollover

  19. Steps to split Tables among on-going running replicate

  20. Steps to split Table among on-going running Extract

  21. Guidelines for the long running session to be taken care before stopping Extract

  22. 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

  23. Re-extracting Pump in case of target trail corruption when checkpoint table available

  24. Re-extracting Pump in case of target trail corruption when no checkpoint table available

  25. Use case to  troubleshoot stuck OGG process

  26. Golden Gate upgrade/migration

Use Case

Use Case 1

Certificate

Certificate
Benefits of Certificate

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.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?