Page Comparison

oracle@dbvlin71[sample]: ./sample-all.sh

Setting up Dbvisit Replicate configuration

Configure database orcl_dbvisit210src...
This check fails if the DBID is not the expected one...

Ok, check passed.

Configure database orcl_dbvisit230tgt...
This check fails if the DBID is not the expected one...

Ok, check passed.
Object grants for database orcl_src...
Object grants for database orcl_dbvisit230tgt...

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.8
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /home/oracle/orclsample/config/orclsample-onetime.ddc loaded.
MINE: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists)
APPLY: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists)
dbvrep> #clear the no-DDC-DB-available warning
dbvrep> process clear previous warnings
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> 
dbvrep> # Configuring default processes
dbvrep> choose process MINE
Process type MINE set to: MINE.
dbvrep> ENGINE choose process APPLY
Process type APPLY set to: APPLY.
dbvrep> PROCESS SWITCH_REDOLOG
Redo log switch requested.dbvrep> PROCESS SETUP MINE DROP DICTIONARY
0 dictionary objects dropped.
dbvrep> ENGINEPROCESS SETUP MINE CREATE DICTIONARY
dbvrep> ENGINEPROCESS SETUP MINE LOAD DICTIONARY

Oldest active transaction SCN: 148315250 (no active transaction)
Supplemental logging on database set.
Loading dictionary table DBRSCCOL$
Loading dictionary table DBRSCDEF$
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> ENGINEPROCESS SETUP APPLY DROP DICTIONARY
0 dictionary objects dropped.
dbvrep> ENGINEPROCESS SETUP APPLY CREATE DICTIONARY
dbvrep> ENGINEPROCESS SETUP APPLY LOAD DICTIONARY
dbvrep> ENGINEPROCESS PREPARE_DP SETUP CLEAR
dbvrep> ENGINEPROCESS 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$
Applier SCN set (start=148315271, current=148315271).
dbvrep> SET APPLY.INSTANTIATE_SCN NOW
Variable INSTANTIATE_SCN set to NOW for process APPLY.
dbvrep> SET MINE._PREPARE_SUPLOG_TYPE PK
Variable _PREPARE_SUPLOG_TYPE set to PK for process MINE.
dbvrep> EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_UNCMP #Ignore tables created by Compression Advisor
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_CMP #Ignore tables created by Compression Advisor
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.SCHEDULER$_% #Ignore tables created by Oracle scheduler (also used by schema/full expdp/impdp)
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.CMP1$% #Ignore tables created by Compression Advisor since 11.2.0.4
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.CMP2$% #Ignore tables created by Compression Advisor since 11.2.0.4
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.CMP3$% #Ignore tables created by Compression Advisor since 11.2.0.4
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.CMP4$% #Ignore tables created by Compression Advisor since 11.2.0.4
Exclude rule created.
dbvrep> SET PREPARE_SCHEMA_EXCEPTIONS none

Variable PREPARE_SCHEMA_EXCEPTIONS set to none for process *.
dbvrep> PROCESS SUPPLEMENTAL LOGGING SCHEMA "SCOTT" ENABLE PRIMARY KEY
dbvrep> PROCESS SWITCH_REDOLOG
Redo log switch requested.dbvrep> PROCESS WAIT_SCN_FLIP
Waited 5 seconds until scn_to_timestamp changed.
dbvrep> #single-scn instantiation: lock all tables and schemas
dbvrep> PROCESS LOCK SCHEMAS "SCOTT"

Locking all schemas.
...locked 9 of 9 tables from SCOTT schema.
Lock done.
dbvrep> #single-scn instantiation: unlock all tables and schemas, but keep the SCN
dbvrep> PROCESS LOCK RELEASE LOCKS
dbvrep> 
dbvrep> #prepare the tables (we use OFFLINE as neither MINE nor APPLY
is running; with OFFLINE we won't wait on network timeout)
dbvrep> PREPARE OFFLINE SCHEMA "SCOTT"
Table SCOTT. space here instantiated at SCN 148319663
Table SCOTT.BIG_TABLE2 instantiated at SCN 148319663
Table SCOTT.BONUS instantiated at SCN 20615855148319663
Table dbvrepSCOTT.DBRSOBJ$DEPT instantiated at SCN 20615855148319663
Table dbvrepSCOTT.DBRSTAB$EMP instantiated at SCN 20615855148319663
Table dbvrepSCOTT.DBRSUSER$SALES instantiated at SCN 20615855148319663
Table dbvrepSCOTT.DBRSV_$DATABASESALES2 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 148319663
Table SCOTT.SALGRADE instantiated at SCN 148319663
Table SCOTT.SSS instantiated at SCN 148319663
dbvrep> 
dbvrep> #single-scn instantiation: unlock all tables and schemas,
forget the SCN (so it does not affect any further PREPARE statements)
dbvrep> PROCESS LOCK CLEAR SCN
dbvrep> PROCESS SWITCH_REDOLOG
Redo log switch requested.dbvrep> #prepare script for instantiation
dbvrep> PROCESS LOAD_REQUEST OFFLINE SCHEMA "SCOTT" AT INSTANTIATE SCN
Table SCOTT. space here will be loaded using SCN 148319663.
Table SCOTT.BIG_TABLE2 will be loaded using SCN 148319663.
Table SCOTT.BONUS will be loaded using SCN 148319663.
Table SCOTT.DEPT will be loaded using SCN 148319663.
Table SCOTT.EMP will be loaded using SCN 148319663.
Table SCOTT.SALES will be loaded using SCN 148319663.
Table SCOTT.SALES2 will be loaded using SCN 148319663.
Table SCOTT.SALGRADE will be loaded using SCN 148319663.
Table SCOTT.SSS will be loaded using SCN 148319663.
dbvrep> create ddcdb from ddcfile
DDC loaded into database (131399 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.
WARN-1850: No DDC DB available, dictionary table does not exist.

These steps are required after the sample-all.sh script runs:
1) Create the necessary directory(ies) on the servers:
dbvlin72.dbvisit: /home/oracle/sample

2) Copy the DDC files to the server(s) where the processes will run:
dbvlin72.dbvisit: /home/oracle/sample/sample-APPLY.ddc
dbvlin71.dbvisit: /home/oracle/sample/sample-MINE.ddc

3) Review that path to dbvrep executable is correct in the run scripts:
/home/oracle/sample/sample-run-dbvlin71.dbvisit.sh
/home/oracle/sample/sample-run-dbvlin72.dbvisit.sh

4) Copy the run script to the server(s) where the processes will run:
dbvlin71.dbvisit: /home/oracle/sample/sample-run-dbvlin71.dbvisit.sh
dbvlin72.dbvisit: /home/oracle/sample/sample-run-dbvlin72.dbvisit.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.

7) Start the replication processes on all servers:
dbvlin71.dbvisit: /home/oracle/sample/sample-run-dbvlin71.dbvisit.sh
dbvlin72.dbvisit: /home/oracle/sample/sample-run-dbvlin72.dbvisit.sh

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

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

oracle@dbvlin71[sample]: