The thumb rule of replication is replication has been configured and installed. The following steps need to be done to complete and start the replication:
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| 1) Create the necessary directory(ies) on the servers:
dbvisit230: /home/oracle/orcl
2) Copy the DDC files to the server(s) where the processes will run:
/home/oracle/orcl/orcl-MINE.ddc
/home/oracle/orcl/orcl-APPLY.ddc
3) Review that path to dbvrep executable is correct in the run scripts:
/home/oracle/orcl/orcl-run-dbvisit230.sh
/home/oracle/orcl/orcl-run-dbvisit210.sh
4) Copy the run script to the server(s) where the processes will run:
/home/oracle/orcl/orcl-run-dbvisit230.sh
/home/oracle/orcl/orcl-run-dbvisit210.sh
5) Ensure firewall is open for listen interfaces dbvisit210:7901, dbvisit230:7902 used by the processes.
6) Make sure the data on apply are in sync as of time when setup was run. Scripts for Data Pump/export/DDL were created as requested:
/home/oracle/orcl/APPLY.sh Create referenced database links (if any) before running the scripts.
7) Start the replication processes on all servers:
/home/oracle/orcl/orcl-run-dbvisit230.sh /home/oracle/orcl/orcl-run-dbvisit210.sh
8) Start the console to monitor the progress:
/usr/bin/dbvrep --ddcfile /home/oracle/orcl/orcl-MINE.ddc |
|
|
The thumb rule of replication is to identical source and target data before starting replication so no conflicts arise. Therefore, Execute APPLY.sh script on target machine to sync target data with source before starting replication.
| Note |
|---|
Run APPLY.sh is empty when source environment (schema/tables) has no datascript 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. |
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:
...