This section initialises and starts the replication processes
...
- SQL scripts. These scripts will run SQL statements in the source or target databases.
- CFG scripts. These are used in the setup wizard to remember user inputs. The setup wizard can be run again and the previous input will be displayed based on information in the .cfg files.
- DDC scripts. These scripts contain all the configurational settings for the replication.
- DBVREP script. This script runs Dbvisit Replicate commands and initialises the replication.
3. The dbvrep_orcl-all.sh is the main script that calls all the other script to initialise the replication. Start this script
...
| No Format |
|---|
These steps are required after the dbvrep_orcl-all.sh script runs: 1) Create the necessary directory(ies) on the servers: target: /home/oracle/dbvrep_orcl 2) Copy the DDC files to the server(s) where the processes will run: target: /home/oracle/dbvrep_orcl/dbvrep_orcl-APPLY.ddc source: /home/oracle/dbvrep_orcl/dbvrep_orcl-MINE.ddc 3) Review that path to dbvrep executable is correct in the run scripts: /home/oracle/dbvrep_orcl/dbvrep_orcl-run-source.sh /home/oracle/dbvrep_orcl/dbvrep_orcl-run-target.sh 4) Copy the run script to the server(s) where the processes will run: source: /home/oracle/dbvrep_orcl/dbvrep_orcl-run-source.sh target: /home/oracle/dbvrep_orcl/dbvrep_orcl-run-target.sh 5) Ensure firewall is open for listen interfaces 0.0.0.0:7902, 0.0.0.0:7901 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/dbvrep_orcl/APPLY.sh Create referenced database links (if any) before running the scripts. 7) Start the replication processes on all servers: source: /home/oracle/dbvrep_orcl/dbvrep_orcl-run-source.sh target: /home/oracle/dbvrep_orcl/dbvrep_orcl-run-target.sh 8) Start the console to monitor the progress: /home/oracle/dbvrep_orcl/start-console.sh The above list is stored in /home/oracle/dbvrep_orcl/Nextsteps.txt. |
6. On the target server (dbv02) create the /home/oracle/dbvrep_orcl directory
| No Format |
|---|
su - oracle [oracle@target ~]$ mkdir /home/oracle/dbvrep_orcl [oracle@target ~]$ |
7. On the source server (dbv01), copy the DDC file to the target server using scp. The Dbvisit Database Configuration file contains all the configurational settings for the replication. The scp password is oracle.
| No Format |
|---|
[oracle@source dbvrep_orcl]$ scp /home/oracle/dbvrep_orcl/dbvrep_orcl-APPLY.ddc oracle@target-int:/home/oracle/dbvrep_orcl/ The authenticity of host 'target-int (10.1.1.11)' can't be established. RSA key fingerprint is 07:15:bb:a2:a6:ba:60:3f:c3:31:a9:c9:4a:7c:51:6a. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'target-int,10.1.1.11' (RSA) to the list of known hosts. oracle@target-int's password: dbvrep_orcl-APPLY.ddc |
8. On the source server (dbv01), copy the dbvrep_orcl-run-target.sh file to the target server using scp. The scp password is oracle
| No Format |
|---|
[oracle@source dbvrep_orcl]$ scp /home/oracle/dbvrep_orcl/dbvrep_orcl-run-target.sh oracle@target-int:/home/oracle/dbvrep_orcl/ oracle@target-int's password: dbvrep_orcl-run-target.sh |
| Note |
|---|
The word "target" in dbvrep_orcl-run-target.sh is dependent on your target system namehostname. In this case, the target system hostname is called target |