Start the replication

Owned by Copy Space for Confluence
Last updated: Dec 07, 2017 by Donna Zehl (Unlicensed)
3 min read

The replication has been configured and installed. The following steps need to be done to complete and start the replication:

Created file /home/oracle/sample/sample-APPLY.ddc.
Created file /home/oracle/sample/sample-MINE.ddc.
Created file /home/oracle/sample/config/sample-setup.dbvrep.
Created file /home/oracle/sample/config/sample-dbsetup_SDB11_dbvrep.sql.
Created file /home/oracle/sample/config/sample-dbsetup_TDB11_dbvrep.sql.
Created file /home/oracle/sample/config/sample-grants_SDB11_dbvrep.sql.
Created file /home/oracle/sample/config/sample-grants_TDB11_dbvrep.sql.
Created file /home/oracle/sample/config/sample-onetime.ddc.
Created file /home/oracle/sample/start-console.sh.
Created file /home/oracle/sample/sample-run-dbvlin71.dbvisit.co.nz.sh.
Created file /home/oracle/sample/scripts/sample-dbvlin71.dbvisit-start-MINE.sh.
Created file /home/oracle/sample/scripts/sample-dbvlin71.dbvisit-stop-MINE.sh.
Created file /home/oracle/sample/scripts/sample-dbvlin71.dbvisit-dbvrep-MINE.sh.
Created file /home/oracle/sample/scripts/systemd-dbvrep-MINE_sample.service.
Created file /home/oracle/sample/scripts/upstart-dbvrep-MINE_sample.conf.
Created file /home/oracle/sample/sample-run-dbvlin72.dbvisit.sh.
Created file /home/oracle/sample/scripts/sample-dbvlin72.dbvisit-start-APPLY.sh.
Created file /home/oracle/sample/scripts/sample-dbvlin72.dbvisit-stop-APPLY.sh
Created file /home/oracle/sample/scripts/sample-dbvlin72.dbvisit-dbvrep-APPLY.sh.
Created file /home/oracle/sample/scripts/systemd-dbvrep-APPLY_sample.service.
Created file /home/oracle/sample/scripts/upstart-dbvrep-APPLY_sample.conf.
Created file /home/oracle/sample/Nextsteps.txt.
Created file /home/oracle/sample/sample-all.sh.
========================================================================================================================
Dbvisit Replicate wizard completed


Script /home/oracle/sample/sample-all.sh created. This runs all the above created scripts. Please exit out of dbvrep, review and run script as current user to setup and start Dbvisit Replicate.
========================================================================================================================
Optionally, the script can be invoked now by this wizard.
Run this script now? (Yes/No) [No]                                                                                       
dbvrep>

 

The thumb rule of replication is that the source and target data is identical before starting replication so no conflicts arise. You may have to 'make' them identical via an initial load or provisioning. Therefore, execute APPLY.sh script on target machine to sync target data with source BEFORE starting replication.

Run APPLY.sh script on target machine to export data from source database and load into target database to create a starting point from where replication can be initiated. Click here for more information on creating starting point. Make sure you review APPLY.sh before running the script.

 

For one-way replication please ensure all triggers are disabled or dropped for the replicated tables/schemas after importing on target else this could lead to data divergence. The trigger has already fired on the source & the resultant transactions will be replicated to the target so there is no need to have them fire again. Same is true for delete cascade constraints as they need to be disabled prior to starting up APPLY process. Sample sql for disabling the delete cascade constraints can be found at Constraints.  If you had any LOB columns with NOT NULL constraints these also need to be deferred or disabled on the target.

 


As indicated by the Nextsteps.txt , the replication can be started by following the steps that are listed above. 

Starting the replication does the following:

  • Starts the MINE and APPLY process in the background
  • Creates the necessary log and plog directories.
  • Once the APPLY and MINE process has been started, there is in INITIALIZATION process. This replicates the contents of the Dbvisit Replication repository from the source to the target database. The replication can not be started until this phase has been completed.

 

In Windows environment, If MINE/APPLY service crashes immediately after the start without showing any error either on screen or in Dbvisit Replicate log, then you have either of following two errors in Windows system log in Windows Event Viewer.

  1. ORA-12705: Cannot access NLS data files or invalid environment specified
  2. Faulting application name: dbvrep.exe, version: 0.0.0.0, time stamp: 0x4da1b651

Please click here to find troubleshooting information for this issue.