Page Comparison

...

1.

...

Pause the apply processes

It is necessary to pause the apply process for both replication directions. To do so choose one replication, pause the first apply process and then choose the second replication a pause the second apply process:

...

dbvrep> choose show
Process MINE chosen, it is a MINE.
Process APPLY chosen, it is a APPLY. 
 

dbvrep> pause apply
Apply requested to pause. 

dbvrep> choose replication mine1
Process type MINE set to: mine1.
Process type APPLY set to: APPLY1.

dbvrep> choose show
Process mine1 chosen, it is a MINE.
Process APPLY1 chosen, it is a APPLY.

dbvrep> pause apply1
Apply requested to pause. 

dbvrep> list status
MINE IS running. Currently at plog 10441 and SCN 43299785 (03/14/2013 11:50:59).
APPLY is PAUSED. Currently at plog 10441 and SCN 43299607 (01/01/1988 00:00:00).
MINE1 IS running. Currently at plog 3298 and SCN 43252417 (03/14/2013 11:50:59).
APPLY1 is PAUSED. Currently at plog 3298 and SCN 43252398 (03/14/2013 11:50:49).

2.

...

Prepare the new table

...

Dbvisit Replicate will give the SCN of where the table will be replicated from.

...

Column
width 5%

Column

width	95%

Panel

bgColor	CCC

dbvrep> choose show
Process MINE chosen, it is a MINE.
Process APPLY chosen, it is a APPLY.
dbvrep> prepare table SCHEMA_RECREATE.schema_recreate_tbl
Connecting to running apply [SCHEMA_RECREATE.schema_recreate_tbl]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [SCHEMA_RECREATE.schema_recreate_tbl]: [Table (un)prepared (4 internal records).]
Table SCHEMA_RECREATE.schema_recreate_tbl instantiated at SCN 43348595
dbvrep> choose replication MINE1
Process type MINE set to: MINE1.
Process type APPLY set to: APPLY1.
dbvrep> show choose
dbvrep> choose show
Process MINE1 chosen, it is a MINE.
Process APPLY1 chosen, it is a APPLY.
dbvrep> prepare table SCHEMA_RECREATE.schema_recreate_tbl
Connecting to running apply [SCHEMA_RECREATE.schema_recreate_tbl]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [SCHEMA_RECREATE.schema_recreate_tbl]: [Table (un)prepared (4 internal records).]
Table SCHEMA_RECREATE.schema_recreate_tbl instantiated at SCN 43298074
dbvrep>

3. Synchronize data

Use the SCN from step 2 to load the historical data (Example use datapump with flashback_scn=xxx)

...

dbvrep> show apply_database
APPLY1.APPLY_DATABASE = UNITSRC
APPLY.APPLY_DATABASE = UNITTRG
APPLY1.APPLY_DATABASE_DBID = 433515465
*.APPLY_DATABASE =
APPLY.APPLY_DATABASE_DBID = 742136697
*.APPLY_DATABASE_DBID =

SET TRANSACTION NAME 'DBREPL_DB_UNITSRC_XID_UNITSRC';
insert into SCHEMA_RECREATE.schema_recreate_tbl (id, member)
select id, member from SCHEMA_RECREATE.schema_recreate_tbl@unittrg
as of scn 43298074;

SET TRANSACTION NAME 'DBREPL_DB_UNITTRG_XID_UNITTRG';
insert into SCHEMA_RECREATE.schema_recreate_tbl (id, member)
select id, member from SCHEMA_RECREATE.schema_recreate_tbl@unitsrc
as of scn 43348595;

4. Resume the replication

...

Column
width 95%
Panel
bgColor CCC
dbvrep> choose replication MINE Process type MINE set to: MINE. Process type APPLY set to: APPLY. dbvrep> resume apply Apply requested to resume. dbvrep> choose replication MINE1 Process type MINE set to: MINE1. Process type APPLY set to: APPLY1. dbvrep> resume apply1 Apply requested to resume.

 

Note that the table needs to exist on the target side before the apply process can be resumed. Using a datapump in step 3 is a good choice, since the import creates table automatically if it does not exist.

...