|Replication Operation Support|
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:
Configure the source (master) Oracle database, including configuring users and CDC configuration to extract the data.
Prepare the target Oracle database. Users must be created, and the DDL from the source Oracle server applied to the target database before replication begins.
Install the Master replicator to extract information from the Oracle database.
Install the Slave replicator to read data from the master replicator and apply it to Oracle.