How to know when source and target are fully synchronized?

Problem Description

How to know when source and target are fully synchronized with Dbvisit Replicate? We need to know when source and target database are fully synchronized in order to switch production to the target database.

Solution

If the tables are at 100% and all the conflicts did not cause data divergence then your data is in sync. To manually verify, you can count all your tables in source and targets and compare the totals.

To verify the data, pause the apply process from dbvrep console by running pause apply command. Get the SCN of the last apply operation from the console and then you can use the following query:

select count(*)
from
(
( select * from tab1@source as of SCN &&SCN
minus
select * from tab1@target )
union all
( select * from tab1@target
minus
select * from tab1@source as of SCN &SCN)
)

Arjen Visser May 25, 2013 11:46