/home/oracle/reptest1/./reptest1-all.sh Setting up Dbvisit Replicate configuration Configure database reptest1... This check fails if the DBID is not the expected one... Ok, check passed. Configure database database=dbvrep Object grants for database reptest1... 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). Dbvisit Replicate version 2.4.21.2687 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/reptest1/reptest1-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 SWITCH_REDOLOG 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 DBRSIND$ 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 09694DAE-9045-11E2-B3F5-D0118AF7C5BA. If not using DDC in database, set MINE_UNIQUE_ID to this value. 1 applier SCN set. dbvrep> SET APPLY.INSTANTIATE_SCN NOW Variable INSTANTIATE_SCN set to NOW for process APPLY. dbvrep> memory_set IGNORE_APPLY_DDL_DIFFERENCES YES Variable IGNORE_APPLY_DDL_DIFFERENCES set to YES for process *. dbvrep> ENGINE SUPPLEMENTAL LOGGING TABLE AVI.SAMPLE ENABLE PRIMARY KEY dbvrep> ENGINE SWITCH_REDOLOG dbvrep> ENGINE WAIT_SCN_FLIP Waited 3 seconds until scn_to_timestamp changed. dbvrep> #single-scn instantiation: lock all tables and schemas dbvrep> ENGINE LOCK TABLES AVI.SAMPLE Locking all tables. Lock done. dbvrep> #single-scn instantiation: unlock all tables and schemas, but keep the SCN dbvrep> ENGINE LOCK RELEASE LOCKS dbvrep> dbvrep> #prepare the tables (we use OFFLINE as neither MINE not APPLY is running; with OFFLINE we won't wait on network timeout) dbvrep> PREPARE OFFLINE TABLE AVI.SAMPLE NODDL RENAME TO reptest1.sample Table AVI.SAMPLE instantiated at SCN 36261160 dbvrep> #single-scn instantiation: unlock all tables and schemas, forget the SCN (so it does not affect any further PREPARE statements) dbvrep> ENGINE LOCK CLEAR SCN dbvrep> ENGINE SWITCH_REDOLOG dbvrep> #prepare script for instantiation dbvrep> ENGINE PREPARE_DP WRITE DDL_FILE FILE /home/oracle/reptest1/APPLY.sql USERID SYSTEM/odb10g@reptest1 Created DDL script /home/oracle/reptest1/APPLY.sql. dbvrep> create ddcdb from ddcfile DDC loaded into database (227 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. These steps are required after the reptest1-all.sh script runs:1) Create the necessary directory(ies) on the servers: dbvldemo102: /home/oracle/reptest12) Copy the DDC files to the server(s) where the processes will run: dbvldemo102: /home/oracle/reptest1/reptest1-APPLY.ddc dbvldemo101: /home/oracle/reptest1/reptest1-MINE.ddc3) Review that path to dbvrep executable is correct in the run scripts: /home/oracle/reptest1/reptest1-run-dbvldemo101.sh /home/oracle/reptest1/reptest1-run-dbvldemo102.sh4) Copy the run script to the server(s) where the processes will run: /home/oracle/reptest1/reptest1-run-dbvldemo101.sh /home/oracle/reptest1/reptest1-run-dbvldemo102.sh5) Ensure firewall is open for listen interfaces 0.0.0.0:7902, 0.0.0.0:7901 used by the processes.6) Ensure firewall is open for remote access to mysql (usually port 3306) on dbvldemo102.7) 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/reptest1/APPLY.sql Create referenced database links (if any) before running the scripts.8) Start the replication processes on all servers: /home/oracle/reptest1/reptest1-run-dbvldemo101.sh /home/oracle/reptest1/reptest1-run-dbvldemo102.sh9) Start the console to monitor the progress: chmod 0750 /home/oracle/reptest1/start-console.sh /home/oracle/reptest1/start-console.shThe above list is stored in /home/oracle/reptest1/Nextsteps.txt. |