Oracle GoldenGate

Oracle GoldenGate The Solution for Enterprise-wide Real Time Data Needs Real-time information Database and applications, Mixed sources, distributed systems, legacy, OLTP, OLAP Mission Critical Applications & Data, Business Intelligence, Reporting for Customers, Partners & Employees Real-time Access Oracle GoldenGate delivers real-time access of real-time information, enabling companies to dramatically improve the availability, reliability, and performance of critical data across enterprise systems.

Value Propositions for Oracle GoldenGate Delivers continuous operations for mission critical applications to eliminate unplanned outages and reduce cost of planned outages. Lowers IT costs through heterogeneous support for multiple platforms to leverage lower cost infrastructure for query offloading. Reduces risk by ensuring data integrity and reliability between source and target systems. Improves business insight through real-time BI Data Warehousing and report offloading. Improves efficiencies through improved performance, scalability of real-time feeds, and data distribution. Reduces barriers to sharing data because of no application impact for real time data acquisition.

Oracle GoldenGate supports multiple setups:

  1. Uni-Directional :- This topology can be used to create a reporting instance out of OLTP databases or to offload the reporting on OLTP or Production database.
  2. Bi-Directional :- Can be used for Active-Active Instant failover.For example,If we want to apply patch on one database we can use another for our application like rolling upgrade in Oracle Real Application Clusters.
  3. Peer-To-Peer :- Used in the case of High Availability and Load Balancing.High Availability mean if any of the database fails because of any reason(Hardware Failure,Disk Failure or Instance Failure) our application would not get affected becuase other two databases will be up and running.Other benefit is that load is also being shared between the databases equally.
  4. Broadcast :- Used for Data Distribution.If we have Production database and we want to do different kind of things (reporting,testing and development)on the data being stored .Then we can distribute the data between same or different databases and can be used for different purposes mentioned above.
  5. Consildation :- If want to create common datawarehouse by consolidating the data from the datamarts of various departments in the enterprise.
  6. Cascading :- Can be used for Scalability and Database Tiering.If want the move the production database to testing database and then to move the results of testing into various other databases of other departments.We can use any of the above topologies in any manner to do cascading like in the diagram is Uni-directional and then Broadcasting is used.


Oracle GoldenGate Topologies

How does it work?

Oracle GoldenGate Use Cases Enterprise-wide Solution for Real Time Data Needs Log Based, Real-Time Change Data Capture Heterogeneous Source Systems EDW ODS EDW Disaster Recovery, Data Protection Zero Downtime Migration and Upgrades Operational Reporting Real-time BI Standby (Open & Active) Reporting Database OGG ETL ETL Query Offloading Data Distribution.

  • Standardize on Single Technology for Multiple Needs
  • Deploy for Continuous Availability and Real-time Data Access for Reporting / BI
  • Highly Flexible
  • Fast Deployments
  • Lower TCO & Improved ROI

See below for a presentation by Oracle detailing the architecture of Oracle GoldenGate and the different solutions that can be built using the tool.

Watch full screen

Oracle GoldenGate Solutions

Oracle GoldenGate Use Cases Enterprise-wide Solution for Real Time Data Needs Log Based, Real-Time Change Data Capture Heterogeneous Source Systems EDW ODS EDW Disaster Recovery, Data Protection Zero Downtime Migration and Upgrades Operational Reporting Real-time BI Standby (Open & Active) Reporting Database OGG ETL ETL Query Offloading Data Distribution.


Oracle GoldenGate Solutions

What we can do for you?

Our consultants are experts in Oracle GoldenGate and able to come and demonstrate the capabilities of this powerful replication tool. We can give you a free initial assessment to see how Oracle GoldenGate can help your company.

Here is a sample of what we can do for you using Oracle GoldenGate, please contact us using the contact page or using the link at the end of this page for a detailed discussion.

  • Oracle GoldenGate complete initial configuration
  • Oracle GoldenGate Performance Tuning
  • Builing the object record for speeding up the startup
  • Monitoring lag statistics
  • GoOldenGate Tuning and Troubleshooting
  • Controling Command Persionns
  • Automating Managing of Trail Files
  • Automating Process Setup
  • Reconfiguring & Restarting Oracle GoldenGate
  • Handling TCP/IP Errors
  • Using Reporting and Statistics
  • Monitoring Processes, Lags and Error Messages
  • Implement Features of GoldenGate Management Pack
  • Extracting Trails and Files
  • Describing and Contrast Extract Trails and Files
  • Investigating Different Formats
  • Viewing Extract Trails and Files with Logdump
  • Reversing the Sequence of Operations in an Extract Trail or File to Back out Changes
  • Contrasting GLOBALS with Process Parameters
  • Describing Commonly-used Parameters for GLOBALS, Manager, Extract and Replicat
  • Using Data Selection and Filtering
  • Selecting and Filtering Data for Replication
  • Mapping Columns Between Different Schemas
  • Using Built-in Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Using Additional Transformation Concepts
  • Creating and Invoking Macros
  • Setting and retrieving User Tokens
  • Running User Exits in GoldenGate Processes
  • Replicating Oracle Sequences
  • Introducing Configuration Options
  • Using BATCHSQL to Speed Delivery
  • Understanding Data Compress Across the Network
  • Enabling Message, Trail and Password Encryption
  • Using Event Records to Automatically Trigger Actions
  • Understanding & Configuring Bidirectional Replication
  • Detecting and Avoid Loops
  • Avoiding, Detecting, and Handling Conflicts
  • Handling Identity Types
  • Setting Up DDL Replication
  • Explaining the Requirements for Oracle DDL Replication
  • Explaining DDL String Subsitution
  • Using GGSCI commands
  • Viewing Checkpoint Details
  • Evaluating a Process Report
  • Evaluating a Log Sample
  • Gather and evaluate systems logs
  • Diagnosing a slow Extract
  • Solving the issue when Extract abends
  • Solving the issue when the Data Pump Extract abends
  • Resolving when Replicat is not moving or abends
  • Preventing Replicat from exiting
  • Resolving Missed Transaction Problems
  • Transactions not being processed
  • Including missed transactions
  • Solve Mapping and Synchronization Problems
  • Solve mapping problems such as missed definitions and colum mappings
  • Syncrhronization issues such as out-of-sync rows, tables without keys, character sets, and DML on target tables
  • Resolving issues due to Time differences

Please contact us to request a demo, or to find out how we can help your business.

You are here:   HomeServicesOther ServicesOracle GoldenGate