Careers360 Logo
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

Back to top