Oracle GoldenGate Best Practices: GoldenGate Capture from a DataGuard with Cascaded Redo Logs

  Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured with cascading redo logs. We outline how to configure the cascade log shipping from the standby to the mining database as well has how to configure the extract process on the mining […]

Oracle GoldenGate: Migrate to Microservices Architecture

Introduction Oracle GoldenGate Microservices Architecture (OGG-MA) is a Restful API microservices based architecture that provides functionality for the configuration, installation, and management of Oracle GoldenGate services using a web-based user interface. In this article, we’ll migrate an existing Oracle GoldenGate Classic (OGG) instance to an OGG-MA deployment. The concepts, scripts, and information presented in this article are […]

Oracle GoldenGate: Apply to Apache Flume File Roll Sink

Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from many different sources to a centralized data store. The Oracle GoldenGate for Big Data Flume Handler is designed to stream change capture data from a Oracle GoldenGate trail to a Flume File Roll […]

Oracle GoldenGate Big Data Adapter: Establishing Secure Connections to Apache Kafka

Introduction When publishing data to Apache Kafka via the Oracle GoldenGate Big Data Kafka Handler, it is a good practice to establish secure connections in order to protect sensitive data from un-authorized snooping. The Oracle Big Data Kafka Handler leverages encryption and authentication features built-in to Apache Kafka. In this article we shall detail the Oracle […]

Oracle GoldenGate Big Data Adapter: Apache Kafka Producer

Introduction Apache Kafka is a distributed, partitioned, replicated commit log service that provides the functionality of a Java Messaging System. The Oracle GoldenGate for Big Data Kafka Handler acts as a Kafka Producer that writes serialized change capture data from an Oracle GoldenGate Trail to a Kafka Topic. In this article we will setup the Oracle GoldenGate Big Data […]

Oracle GoldenGate Big Data: Apply to Apache HDFS

Introduction Oracle GoldenGate for Big Data provides runtime, pluggable functionality into the Oracle GoldenGate Java Delivery framework in order to stream transactional data into big data systems, raising the quality and timeliness of business insights. In this article we shall setup the Oracle GoldenGate Apply mechanism (Replicat) to stream data captured from an Oracle 12c Multi-tenant Database […]

Oracle GoldenGate extract recovery (Missing archivelogs)

  Issue description: The issue occurs when archive logs that are needed by Oracle GoldenGate extract gets deleted. For example this can happen when purging old archive logs using RMAN with “force” option. RMAN is integrated with OGG so under normal circumstances RMAN never deletes an archive log that is required by OGG extract. But […]

Oracle GoldenGate: DDL Replication To Oracle Targets With Dissimilar Data Structure

Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this […]

Oracle GoldenGate: Capture and Apply of Microsoft SQL Server DDL Operations

Introduction Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other databases require a lot of coordination and typically an extended OGG outage. In this article we shall discuss one option for automating the capture, delivery, and execution of DDL operations using OGG […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC) via Oracle Cloud Gateway VPN

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Oracle Cloud Gateway Virtual Private Network (VPN) using Corente Services Gateway. Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning […]

Oracle GoldenGate: Data Replication to DBCS via Mid-Tier Server

Introduction Oracle GoldenGate may be used to apply transactional data into, and extract transactional data from, the Oracle Database Cloud Service (DBCS). In this article we shall demonstrated the remote capture and apply of transactional data between an on-premises Oracle Database and DBCS via a mid-tier server running Oracle GoldenGate (OGG). The concepts presented in […]

Integration of GGCS with EHCS

  Introduction This document will walk you through how to integrate Oracle GoldenGate Cloud Services (GGCS) with Oracle Event Hub Cloud Services (EHCS). The enterprise edition of GGCS supports Oracle GoldenGate Adapter for Big Data which can be used to stream real time data in to Confluent Kafka, running on EHCS. This document covers provisioning […]

Oracle GoldenGate: Monitoring via Restful API

Introduction Oracle GoldenGate version 12.1 introduced the ability to monitor on-premises and GoldenGate Cloud Service instances via a Restful API interface. In this article we will show how to enable monitoring and how to obtain information via Restful API for Oracle GoldenGate on-premises instances running version 12.1 or 12.2 and GoldenGate Cloud Service running version 12.2. Main Article Before […]

Oracle GoldenGate: Teradata Instantiation

Introduction When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this; including various third-party applications that most customers have in-house. In this article, we will demonstrate a zero down-time data replication implementation from an Oracle 12c Pluggable Database to […]

Oracle GoldenGate: Microsoft SQL Server to Oracle Migration (Part 2)

Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In this part, we will do the same zero-downtime migration using Oracle SQL Developer to create the target schema and […]

Oracle GoldenGate: Microsoft SQL Server to Oracle Migration (Part 3)

Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In Part 2, we performed the same zero-downtime migration using Oracle SQL Developer and Oracle GoldenGate. In this part, […]

Oracle GoldenGate: Microsoft SQL Server to Oracle Migrations (Part 1)

Introduction Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with target database instantiation. In this series of articles we shall explore three options for migrating a Microsoft SQL Server Database to an Oracle Database. In Part 1, we’ll use the Microsoft Import and Export Data […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS Oracle Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC)

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via GoldenGate Cloud Service (GGCS). Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning of Oracle GGCS and DBCS are not […]

Oracle GoldenGate: Network Apply to SQL Server

Introduction Oracle GoldenGate (OGG) best practices dictate that the OGG Apply process run on the target database server. However, there are instances where this configuration is not practical. In this article we shall discuss a solution where OGG Apply may be configured on a mid-tier server and apply data over a network to a remote SQL […]