$ ./orcl-all.sh
Setting up Dbvisit Replicate configuration
Configure database ttorcl...
Configure database database=dbvrep
Object grants for database ttorcl...
Object grants for database database=dbvrep
Setting up the configuration
Initializing.....done
WARN-1850: No DDC DB available, dictionary table does not exist.
DDC loaded from database (0 variables).
OK-9056: Directory /home/oracle/orcl/ddc_backup set by variable DDC_BACKUP_DIR does not exist on this system.
OK-9056: Directory /home/oracle/orcl/ddc_backup set by variable DDC_BACKUP_DIR does not exist on this system.
Dbvisit Replicate version 2.1.04.1047
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 SETUP PAIR MINE AND APPLY
ID of mine proces is 276F6266-243F-11E1-A450-BD91EEFD88F8. If not using DDC in database, set MINE_UNIQUE_ID to this value. Table dbvrep.DBRSCOL$ instantiated at SCN 7436161 Table dbvrep.DBRSOBJ$ instantiated at SCN 7436161 Table dbvrep.DBRSTAB$ instantiated at SCN 7436161 Table dbvrep.DBRSUSER$ instantiated at SCN 7436161 Table dbvrep.DBRSV_$DATABASE instantiated at SCN 7436161 1 applier SCN set. dbvrep> PREPARE OFFLINE TABLE scott.avi_objects NODDL Table scott.avi_objects instantiated at SCN 7437937 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. 1) Create the necessary directory(ies) on the servers: 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-dhcppc13.sh 4) Copy the run script to the server(s) where the processes will run: /home/oracle/orcl/orcl-run-dhcppc13.sh 5) Ensure firewall is open for listen interfaces dhcppc13:7901, dhcppc13: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 7) Start the replication processes on all servers: /home/oracle/orcl/orcl-run-dhcppc13.sh 7 8) Start the console to monitor the progress: /usr/bin/dbvrep --ddcfile /home/oracle/orcl/orcl-MINE.ddc |