6.1.4. Creating an Oracle to Oracle Deployment

Replication Operation Support
Statements Replicated No
Rows Replicated Yes
Schema Replicated No
ddlscan Supported No

An Oracle to Oracle deployment replicates data between two Oracle servers, either for scaling or Data Recovery (DR) support. Enabling the Oracle to Oracle replication consists of the following parameters during replication:

  • Data is replicated using row-based replication; data is extracted by row from the source Oracle database and applied by row to the target Oracle database.

  • DDL is not replicated; schemas and tables must be created on the target database before replication starts.

  • Tungsten Replicator relies on two different users within Oracle configuration the configuration, both are created automatically during the CDC configuration:

    • Publisher — the user designated to issue the CDC commands and generates and is responsible for the CDC table data.

    • Subscriber — the user that reads the CDC change table data for translation into THL.

  • The slave replicator (applier), writes information into the target Oracle database using a standard JDBC connection.

The basic process for creating an Oracle to Oracle deployment is: