Page Comparison

[oracle@]$ ./TEST-EC2-all.sh
Setting up Dbvisit Replicate configuration
Configure database SOURCEDBSOURCE_DB...
This check fails if the DBID is not the expected one...




Ok, check passed.
Configure database EC2_TARGET...
This check fails if the DBID is not the expected one...




Ok, check passed.
Object grants for database SOURCE_DB...
Object grants for database EC2_TARGET...
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.6
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /home/oracle/RDSPOCTEST/config/RDSPOCTEST-EC2-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
ID of mine proces is 5B57FC60-2978-11E3-A0AD-58D8E5C48113. If not using DDC in database, set MINE_UNIQUE_ID to this value.
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
1 applier SCN set.
dbvrep> SET APPLY.INSTANTIATE_SCN NOW
Variable INSTANTIATE_SCN set to NOW for process APPLY.
dbvrep> ENGINE SUPPLEMENTAL LOGGING SCHEMA OE ENABLE PRIMARY KEY
dbvrep> ENGINE SWITCH_REDOLOG
dbvrep> ENGINE WAIT_SCN_FLIP
Waited 2 seconds until scn_to_timestamp changed.
dbvrep> #single-scn instantiation: lock all tables and schemas
dbvrep> ENGINE LOCK SCHEMAS OE
Locking all schemas.
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 SCHEMA OE
Table OESCOTT.CUSTOMERSEMP instantiated at SCN 1229827
Table OESCOTT.INVENTORIESDEPT instantiated at SCN 1229827
Table OESCOTT.LOGONSALGRADE instantiated at SCN 1229827
Table OESCOTT.ORDERENTRY_METADATALOADTEST instantiated at SCN 1229827

Table OE.ORDERS instantiated at SCN 1229827
Table OE.ORDER_ITEMS instantiated at SCN 1229827
Table OE.PRODUCT_DESCRIPTIONS instantiated at SCN 1229827
Table OE.PRODUCT_INFORMATION instantiated at SCN 1229827
Table OE.WAREHOUSES instantiated at SCN 1229827
dbvrep> #single-scn instantiation: unlock all tables and schemas, forget the SCN (so it does not affect any further PREPARE statements)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 DP_NETWORKLINK DIRECTORY DATA_PUMP_DIR FILE /home/oracle/RDSPOCTEST/APPLY.sh DBLINK XExx USERID dbvadminsystem/xxxx@AWSDBxxxx@EC2_TARGET
Created Data Pump script /home/oracle/RDSPOCTEST/APPLY.sh, using network import.
dbvrep> create ddcdb from ddcfile
DDC loaded into database (266 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, but some operation(s) raised warnings and/or errors.
These steps are required after the RDSPOCEC2-TEST-all.sh script runs:


1) Create the necessary directory(ies) on the servers:
dbvrds02ec2-54-82-3-111.compute-1.amazonaws.com: /home/oracle/RDSPOCTEST


2) Copy the DDC files to the server(s) where the processes will run:
dbvrds02ec2-54-82-3-111.compute-1.amazonaws.com: /home/oracle/RDSPOCTESTC/RDSPOCEC2-TEST-APPLY.ddc
dbvrds01sourceserver.com: /home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-MINE.ddc


3) Review that path to dbvrep executable is correct in the run scripts:
/home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-run-dbvrds01sourceserver.sh
/home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-run-dbvrds02-ec2-54-82-3-111.compute-1.amazonaws.com.sh


4) Copy the run script to the server(s) where the processes will run:
dbvrds01sourceserver.com: /home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-run-dbvrds01.sh
dbvrds02ec2-54-82-3-111.compute-1.amazonaws.com: /home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-run-dbvrds02.sh-ec2-54-82-3-111.compute-1.amazonaws.com.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/RDSPOC/APPLY.sh
Create referenced database links (if any) before running the scripts.


7) Start the replication processes on all servers:
dbvrds01sourceserver.com: /home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-run-dbvrds01sourceserver.com.sh
dbvrds02ec2-54-82-3-111.compute-1.amazonaws.com: /home/oracle/RDSPOCTEST/RDSPOCEC2-TEST-run-dbvrds02-ec2-54-82-3-111.compute-1.amazonaws.com.sh


8) Start the console to monitor the progress:
/home/oracle/RDSPOCTEST/start-console.sh


The above list is stored in /home/oracle/RDSPOCTEST/Nextsteps.txt.