We're here to help!

How to know when source and target are fully synchronized?

Follow
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

Have more questions? Submit a request

Comments

  • Avatar
    Kamal

    Hi ;
    oki..!
    Here even it 's synced manually using
    MCSETEST2CSD.P_DATES

    Still it has some gaps.
    select count(*)
    from (
    ( select * from MCSETEST2CSD.P_DATES@DBVCSE
    minus
    select * from MCSETEST2CSD.P_DATES )
    union all
    ( select * from MCSETEST2CSD.P_DATES
    minus
    select * from MCSETEST2CSD.P_DATES@DBVCSE )
    );