Chapter 5. Heterogeneous Oracle Deployments

Table of Contents

5.1. Oracle Replication using Redo Reader
5.1.1. Oracle Redo Reader Replication Operation
5.1.2. Preparing the Oracle Environment for Replication
5.1.3. Installing an Oracle to Oracle Deployment
5.1.4. Setting the Replication Start Position
5.1.5. Provisioning an Oracle Replication Solution
5.1.6. Oracle Redo Reader Tuning
5.1.7. Changing the Configured Schema
5.2. Deploying Oracle Replication for Disaster Recovery
5.2.1. Prepare: Oracle Replication for Disaster Recovery
5.2.2. Install: Oracle Replication for Disaster Recovery
5.2.3. Best Practices: Oracle Replication for Disaster Recovery
5.3. Deploying Oracle Replication for Migration
5.3.1. Prepare: Oracle Replication for Migration
5.3.2. Install: Oracle Replication for Migration
5.3.3. Best Practices: Oracle Replication for Migration
5.4. Deploying Oracle to MySQL Replication
5.4.1. Prepare: Oracle to MySQL Replication
5.4.2. Install: Oracle to MySQL Replication
5.4.3. Best Practices: Oracle to MySQL Replication
5.5. Deploying Oracle to Hadoop Replication
5.5.1. Prepare: Oracle to Hadoop Replication
5.5.2. Install: Oracle to Hadoop Replication
5.5.3. Best Practices: Oracle to Hadoop Replication
5.6. Deploying Oracle to Vertica Replication
5.6.1. Prepare: Oracle to Vertica Replication
5.6.2. Install: Oracle to Vertica Replication
5.6.3. Best Practices: Oracle to Vertica Replication
5.7. Deploying Oracle Replication using CDC
5.7.1. How Oracle Extraction Works
5.7.2. Data Type Differences and Limitations
5.7.3. Creating an Oracle to MySQL Deployment
5.7.4. Creating an Oracle to Oracle Deployment
5.7.5. Deployment with Provisioning
5.7.6. Updating CDC after Schema Changes
5.7.7. CDC Cleanup and Correction
5.7.8. Tuning CDC Extraction
5.7.9. Troubleshooting Oracle CDC Deployments

Heterogeneous deployments cover installations where data is being replicated between two different database solutions. These include, but are not limited to:

  • MySQL to Oracle, Oracle to MySQL and Oracle to Oracle, using the Redo Reader.

  • MySQL to Oracle, Oracle to MySQL and Oracle to Oracle, using the Oracle CDC.

The following sections provide more detail and information on the setup and configuration of these different solutions.