Careers360 Logo
Browse by Stream
Search Colleges, Exams, Schools & more
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare

Quick Facts

Medium Of InstructionsMode Of LearningMode Of Delivery
EnglishSelf StudyVideo and Text Based

Courses and Certificate Fees

Certificate AvailabilityCertificate Providing Authority
yesUniversity of Birmingham, Birmingham

The Syllabus

  • 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

  • The Two Oracle GoldenGate Architectures
  • Classic Architecture
  • Extracts
  • Initial Loads
  • Checkpoints
  • The Interaction Between Oracle GoldenGate and Oracle RDBMS

  • 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

  • Configuration Overview
  • Preparing the Environment
  • Enabling Oracle GoldenGate in the Database
  • Enabling Supplemental Logging
  • Defining Roles and Permissions
  • Starting the Manager
  • Configuring Data Capture

  • 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

  • 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

  • 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

  • GLOBALS
  • Manager
  • Source Manager Parameters
  • Target Manager Parameters
  • Extract
  • Extract Parameters on the Source Database
  • Replicat
  • Options Common to Both Replicat and Extract

  • Mapping and Manipulation
  • Definition Files
  • Data Selection
  • Where
  • Filter
  • Mapping
  • SQLEXEC

  • Pictorial view
  • Configurations
  • Data looping’s
  • Resolving conflicts
  • Effect of Oracle Sequences

  • Overview of data mapping and manipulation
  • Deciding where data mapping and conversion will take place Data Selection and Filtering
  • Data Transformation

Articles

Similar College

Similar Courses

American Government Constitutional Foundations

Harvard University, Cambridge via  Edx

Months 4Free

US Political Institutions Congress Presidency Courts and Bureaucracy

Harvard University, Cambridge via  Edx

Months 4Free
View All Courses

More Courses by University of Birmingham, Birmingham

Good Brain Bad Brain Basics

University of Birmingham, Birmingham via  Futurelearn

Months 3Free

Healthy Ageing Concepts Interventions and Preparing for the Future

University of Birmingham, Birmingham via  Futurelearn

Months 3Free

Education Research that Matters Doing Research in Your Learning Community

University of Birmingham, Birmingham via The Chartered College of Teaching, London Futurelearn

Months 4Free
View All Courses

Explore on Careers360

Download Careers360 App's

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

  • student
    250M+

    Students

  • colleges
    30,000+

    Colleges

  • exams
    500+

    Exams

  • ebook
    1500+

    E-Books

  • certification
    12000+

    Cetifications

student
Mobile Screen

We Appeared in

Back to top