...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| Setting up Dbvisit Replicate configuration
Configure database orcl_dbvisit210...
Configure database orcl_dbvisit230...
Object grants for database orcl...
Object grants for database orcl_dbvisit230...
Setting up the configuration
Initializing.....done
WARN-1850: No DDC DB available, dictionary table does not exist.
DDC loaded from database (0 variables).
Dbvisit Replicate
Copyright (C) Dbvisit Software Limited. All rights reserved.
DDC file /home/oracle/orcl/orcl-onetime.ddc loaded.
MINE: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists)
APPLY: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists)
dbvrep> set ON_WARNING SKIP
Variable ON_WARNING set to SKIP for process *.
dbvrep> set ON_ERROR EXIT
Variable ON_ERROR set to EXIT for process *.
dbvrep> ENGINE SETUP MINE DROP DICTIONARY
0 dictionary objects dropped.
dbvrep> ENGINE SETUP MINE CREATE DICTIONARY
dbvrep> ENGINE SETUP MINE LOAD DICTIONARY
Supplemental logging on database set.
Loading dictionary table DBRSCOL$
Loading dictionary table DBRSOBJ$
Loading dictionary table DBRSTAB$
Loading dictionary table DBRSUSER$
Loading dictionary table DBRSV_$DATABASE
dbvrep> ENGINE SETUP APPLY DROP DICTIONARY
0 dictionary objects dropped.
dbvrep> ENGINE SETUP APPLY CREATE DICTIONARY
dbvrep> ENGINE SETUP APPLY LOAD DICTIONARY
dbvrep> ENGINE PREPARE_DP SETUP CLEAR
dbvrep> ENGINE SETUP PAIR MINE AND APPLY
ID of mine proces is A8793C78-1EEB-11E1-816F-70EC8BE7EEF4. If not using DDC in database, set MINE_UNIQUE_ID to this value.
Table dbvrep.DBRSCOL$ instantiated at SCN 20615855
Table dbvrep.DBRSOBJ$ instantiated at SCN 20615855
Table dbvrep.DBRSTAB$ instantiated at SCN 20615855
Table dbvrep.DBRSUSER$ instantiated at SCN 20615855
Table dbvrep.DBRSV_$DATABASE instantiated at SCN 20615855
1 applier SCN set.
dbvrep> PREPARE OFFLINE SCHEMA AVI
dbvrep> PREPARE OFFLINE TABLE SCOTT.AVI_OBJECTS
Table SCOTT.AVI_OBJECTS instantiated at SCN 20626026
dbvrep> ENGINE PREPARE_DP WRITE DP_NETWORKLINK DIRECTORY DATA_PUMP_DIR FILE /home/oracle/orcl/APPLY.sh DBLINK orcl USERID SYS/oracle@orcl_dbvisit230
Created Data Pump script /home/oracle/orcl/APPLY.sh, using network import.
dbvrep> create ddcdb from ddcfile
DDC loaded into database (131 variables).
dbvrep> set ON_WARNING SKIP
Variable ON_WARNING set to SKIP for process *.
dbvrep> set ON_ERROR SKIP
Variable ON_ERROR set to SKIP for process *.
OK-0: Completed successfully. |
|
|
The 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 |
|
|
| Note |
|---|
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. |