Page Comparison

Active - Active or 2-way replication is very similar to 1-way replication. This is used when changes can be made to both databases and they both must be kept in sync.

...

Section

Column

width	5%

Column

width	95

Panel

bgColor	CCC

$

oracle@dbvldemo101[/home/oracle/reptest1]: ./

orcl

reptest1-all.sh 
Setting up Dbvisit Replicate configuration
Configure database

orcl

 reptest1...

Configure database test11202

This check fails if the DBID is not the expected one...

Object grants for database orcl...
Object grants for database test11202...
Setting up the


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


Ok, check passed.
Object grants for database reptest1...
Object grants for database reptest2...
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.

3

4.

07

31.

1500

3038
Copyright (C) Dbvisit Software Limited. All rights reserved.
DDC file /home/oracle/

orcl

reptest1/

orcl

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 PREPARE_DP SETUP CLEAR
dbvrep> ENGINE SETUP PAIR MINE AND APPLY
ID of mine proces is

2CA73994

 F8908CFE-

84F1

F408-

11E1

11E2-

BB7A

ABE7-

022F870D6567

37F589F7C5BA. 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> ENGINE SUPPLEMENTAL LOGGING SCHEMA

AVI

 TEST1 ENABLE PRIMARY KEY
dbvrep> ENGINE SUPPLEMENTAL LOGGING TABLE

SCOTT.AVI_OBJECTS ENABLE PRIMARY

 AVI.EMP ENABLE PRIMARY KEY
dbvrep> ENGINE SWITCH_REDOLOG
dbvrep>

#single-scn instantiation: lock all tables and schemas
dbvrep> ENGINE LOCK TABLES SCOTT.AVI_OBJECTS
Locking all

 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.EMP
Locking all tables.
Lock done.
dbvrep> ENGINE LOCK SCHEMAS

AVI

 TEST1
Locking all schemas.
Lock done.
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 AVI
dbvrep> PREPARE OFFLINE TABLE SCOTT.AVI_OBJECTS
Table SCOTT.AVI_OBJECTS instantiated at SCN 46697269
dbvrep> #single-scn instantiation: unlock all tables and schemas
dbvrep> ENGINE LOCK RELEASE ALL
dbvrep> ENGINE SWITCH_REDOLOG
dbvrep> #prepare script for instantiation
dbvrep> ENGINE PREPARE_DP WRITE DP_NETWORKLINK DIRECTORY DATA_PUMP_DIR FILE /home/oracle/orcl/APPLY.sh DBLINK orcl USERID SYSTEM/oracle@test11202
Created Data Pump script /home/oracle/orcl/APPLY.sh, using network import.
dbvrep>
dbvrep> # Configuring non-default processes
dbvrep> choose process MINE1
Process type MINE set to: MINE1.
dbvrep> choose process APPLY1
Process type APPLY set to: APPLY1.
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 LOAD DICTIONARY
dbvrep> ENGINE PREPARE_DP SETUP CLEAR
dbvrep> ENGINE SETUP PAIR MINE AND APPLY
ID of mine proces is 3E68F0B4-84F1-11E1-BB7A-022F870D6567. If not using DDC in database, set MINE_UNIQUE_ID to this value.
1 applier SCN set.
dbvrep> SET APPLY1.INSTANTIATE_SCN NOW
Variable INSTANTIATE_SCN set to NOW for process APPLY1.
dbvrep> ENGINE SUPPLEMENTAL LOGGING SCHEMA AVI ENABLE PRIMARY KEY
dbvrep> ENGINE SUPPLEMENTAL LOGGING TABLE SCOTT.AVI_OBJECTS ENABLE PRIMARY KEY
dbvrep> ENGINE SWITCH_REDOLOG
dbvrep> #single-scn instantiation: lock all tables and schemas
dbvrep> ENGINE LOCK TABLES SCOTT.AVI_OBJECTS
Locking all tables.
Lock done.
dbvrep> ENGINE LOCK SCHEMAS AVI
Locking all schemas.
Lock done.
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 AVI
dbvrep> PREPARE OFFLINE TABLE SCOTT.AVI_OBJECTS
Table SCOTT.AVI_OBJECTS instantiated at SCN 17535221
dbvrep> #single-scn instantiation: unlock all tables and schemas
dbvrep> ENGINE LOCK RELEASE ALL
dbvrep> ENGINE SWITCH_REDOLOG
dbvrep> #prepare script for instantiation
dbvrep> ENGINE PREPARE_DP WRITE DP_NETWORKLINK DIRECTORY DATA_PUMP_DIR FILE /home/oracle/orcl/APPLY1.sh DBLINK test11202 USERID SYSTEM/oracle@orcl
Created Data Pump script /home/oracle/orcl/APPLY1.sh, using network import.
dbvrep> create ddcdb from ddcfile
DDC loaded into database (241 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:
dbvisit400.dbvisit.com: /home/oracle/orcl

2) Copy the DDC files to the server(s) where the processes will run:
/home/oracle/orcl/orcl-APPLY.ddc
/home/oracle/orcl/orcl-APPLY1.ddc
/home/oracle/orcl/orcl-MINE.ddc
/home/oracle/orcl/orcl-MINE1.ddc

3) Review that path to dbvrep executable is correct in the run scripts:
/home/oracle/orcl/orcl-run-dbvisit400.dbvisit.com.sh
/home/oracle/orcl/orcl-run-rac11202node1.sh

4) Copy the run script to the server(s) where the processes will run:
/home/oracle/orcl/orcl-run-dbvisit400.dbvisit.com.sh
/home/oracle/orcl/orcl-run-rac11202node1.sh

5) Ensure firewall is open for listen interfaces dbvisit400.dbvisit.com:7902, rac11202node1:7904, rac11202node1:7901, dbvisit400.dbvisit.com:7903 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

 #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 TEST1
Table TEST1.DEPT instantiated at SCN 7849244
Table TEST1.EMP instantiated at SCN 7849244
dbvrep> PREPARE OFFLINE TABLE AVI.EMP
Table AVI.EMP instantiated at SCN 7849244
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/reptest1/APPLY.sh DBLINK reptest1 USERID
SYSTEM/odb10g@reptest2
Created Data Pump script /home/oracle/reptest1/APPLY.sh, using network import.
dbvrep> 
dbvrep> # Configuring non-default processes
dbvrep> choose process MINE1
Process type MINE set to: MINE1.
dbvrep> choose process APPLY1
Process type APPLY set to: APPLY1.
dbvrep> ENGINE SWITCH_REDOLOG
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 LOAD DICTIONARY
dbvrep> ENGINE PREPARE_DP SETUP CLEAR
dbvrep> ENGINE SETUP PAIR MINE AND APPLY
ID of mine proces is 0695067C-F409-11E2-ABE7-37F589F7C5BA. If not using DDC in database, set MINE_UNIQUE_ID to this value.
1 applier SCN set.
dbvrep> SET APPLY1.INSTANTIATE_SCN NOW
Variable INSTANTIATE_SCN set to NOW for process APPLY1.
dbvrep> ENGINE SUPPLEMENTAL LOGGING SCHEMA TEST1 ENABLE PRIMARY KEY
dbvrep> ENGINE SUPPLEMENTAL LOGGING TABLE AVI.EMP 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 TABLES AVI.EMP
Locking all tables.
Lock done.
dbvrep> ENGINE LOCK SCHEMAS TEST1
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 TEST1
Table TEST1.DEPT instantiated at SCN 7830009
Table TEST1.EMP instantiated at SCN 7830009
dbvrep> PREPARE OFFLINE TABLE AVI.EMP
Table AVI.EMP instantiated at SCN 7830009
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/reptest1/APPLY1.sh DBLINK reptest2
USERID SYSTEM/odb10g@reptest1
Created Data Pump script /home/oracle/reptest1/APPLY1.sh, using network import.
dbvrep> create ddcdb from ddcfile
DDC loaded into database (291 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 reptest1-all.sh script runs:

1) Create the necessary directory(ies) on the servers:
dbvldemo102: /home/oracle/reptest1

2) 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-APPLY1.ddc
dbvldemo101: /home/oracle/reptest1/reptest1-MINE.ddc
dbvldemo102: /home/oracle/reptest1/reptest1-MINE1.ddc

3) 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.sh

4) 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.sh

5) Ensure firewall is open for listen interfaces 0.0.0.0:7902, 0.0.0.0:7904, 0.0.0.0:7901, 0.0.0.0:7903 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/reptest1/APPLY.sh
/home/oracle/

orcl

reptest1/APPLY1.sh
Create referenced database links (if any) before running the scripts.

7) Start the replication processes on all servers:
/home/oracle/

orcl

reptest1/

orcl

reptest1-run-

dbvisit400

dbvldemo101.

dbvisit.com.

sh
/home/oracle/

orcl

reptest1/

orcl

reptest1-run-

rac11202node1

dbvldemo102.sh

8) Start the console to monitor the progress:

chmod 0750

/home/oracle/

orcl/start-console.sh
/home/oracle/orcl

reptest1/start-console.sh

The above list is stored in /home/oracle/

orcl

reptest1/Nextsteps.txt.

Each run script (orcl reptest1-run-dbvisit400dbvldemo101.dbvisit.com.sh and orclreptest1-run-rac11202node1dbvldemo102.sh) has commands to start both a Mine and Apply on each server.

Dbvisit Replicate command console

...

Section

Column

width	5%

Column

width	95

Panel

bgColor	CCC

/

MINE IS running. Currently at

plog 12 (redo sequence 1391 [1] 1796 [2]) and SCN 46709633 (04/12/2012 18:50:45

 plog 481 and SCN 7855698 (07/24/2013 14:39:46).
APPLY IS running. Currently at plog

12

 481 and SCN

46708889

 7855694 (

04

07/

12/2012 18:50:34

24/2013 14:39:45).

APPLY1

MINE1 IS running. Currently at plog

349

 319 and SCN

17550807

 7836453 (

04

07/

12/2012 18:56:31

24/2013 14:24:54).

MINE1

APPLY1 IS running. Currently at plog

349

 319 and SCN

17550829

 7836451 (

04

07/

12/2012 18:56:35

24/2013 14:24:54).
Progress of replication

orcl

 reptest1:MINE->APPLY: total/this execution

---

----------------------------------------------------------------------------------------------------------------------

-------------------
-----------------------------------------------------------------


AVI.EMP: 100% Mine:14/14 Unrecov:0/0 Applied:14/14 Conflicts:0/0 Last:24/07/2013 14:23:49/OKTEST1.EMP: 100% Mine:14/14 Unrecov:0/0 Applied:14/14 Conflicts:0/0 Last:24/07/2013 14:23:34/OKTEST1.DEPT: 100% Mine:4/4 Unrecov:0/0 Applied:4/4 Conflicts:0/0 Last:24/07/2013 14:23:39/OK
---------------------------------------------------------------------------

0 tables listed.
Progress of replication orcl:MINE1->APPLY1: total/this execution

-------------------------------------------

---


3 tables listed.
Progress of replication reptest1:MINE1->APPLY1: total/this execution
---------------------------------------------------------------------------------------------------------

------------------------------------
-

-------------
TEST1.EMP: 100% Mine:14/14 Unrecov:0/0 Applied:14/14 Conflicts:0/0 Last:24/07/2013 14:39:06/OK
TEST1.DEPT: 100% Mine:4/4 Unrecov:0/0 Applied:4/4 Conflicts:0/0 Last:24/07/2013 14:39:21/OK
AVI.EMP: 100% Mine:14/14 Unrecov:0/0 Applied:14/14 Conflicts:0/0 Last:24/07/2013 14:39:41/OK
----------------------------------------------------------------------------------------------------------------------

---------------------
0 tables listed.


3 tables listed.

With 2-way replication the table listing in the console can so long that the prompt cannot be seen. By default, 30 tables are listed for each replication, thus for a 2-way replication, it takes up to 70 screen lines.
To change this, edit the *-MINE.ddc file and add line "set STATUS_BAR_ACTIVE_TABLES 5". Or enter this command at the console prompt. Restart the console for this change to take affect.

CHOOSE REPLICATION

By default all commands in the Dbvisit Replicate console work with the default processes MINE and APPLY. The choose replication command is useful when working with 2-way replication where there are multiple processes such as MINE, APPLY, MINE1 and APPLY1.

Note that the CHOOSE REPLICATION command selects all processes for the indicated replication (so both Mine and Apply processes).

Example:

Panel

bgColor	CCC

dbvrep> CHOOSE REPLICATION MINE1

The above command will choose the replication pair that is associated with MINE1. Typically this is MINE1->APPLY1.

Note that the CHOOSE REPLICATION command is needed prior to issuing commands to display, resolve and set conflicts for the APPLY1 process.

...

Versions Compared

Old Version 14

New Version 15

Key