Versions Compared

Old Version 1

changes.mady.by.user KrupeshD

Saved on

compared with

New Version 2

changes.mady.by.user KrupeshD

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
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
Note

Run APPLY.sh script on target machine to load data from source database to target database to sync source and target environment before starting replication.