OraFAQ Forum: Streams & AQ » Table not in sync in bi-directional streams replication

Home » Server Options » Streams & AQ » Table not in sync in bi-directional streams replication (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table not in sync in bi-directional streams replication [message #382492]

Thu, 22 January 2009 11:32

upanwar82
Messages: 5
Registered: January 2009
Location: Cincinnati

Junior Member

I have implemented oracle two way streams replication setup.

But some tables are out of sync now i want to bring in sync.
Do we have anything that we can do it without stopping the capture and porpagation process..

Or other way ...

Thanks,
Singh

Report message to a moderator

Re: Table not in sync in bi-directional streams replication [message #382728 is a reply to message #382492]

Fri, 23 January 2009 15:05

varunvir
Messages: 389
Registered: November 2007

Senior Member

Check dba_apply_errors and resolve the erros.After
resolveing the errors delete all of them.You have
to write conflict handler to automate the process to some
extent.
Regards,
Varun Punj,

Report message to a moderator

Re: Table not in sync in bi-directional streams replication [message #382735 is a reply to message #382728]

Fri, 23 January 2009 15:49

upanwar82
Messages: 5
Registered: January 2009
Location: Cincinnati

Junior Member

I have already implemented conflict handler .
for all tables.

Report message to a moderator

Re: Table not in sync in bi-directional streams replication [message #382740 is a reply to message #382735]

Fri, 23 January 2009 19:59

varunvir
Messages: 389
Registered: November 2007

Senior Member

Then check the errors and resolve them to make data in sync.
Regards,
Varun Punj,

Report message to a moderator

Re: Table not in sync in bi-directional streams replication [message #407585 is a reply to message #382740]

Wed, 10 June 2009 11:08

upanwar82
Messages: 5
Registered: January 2009
Location: Cincinnati

Junior Member

Hello,

I resolved all the error and deelte all the errors from dba_apply_error.

But is there is any permanent solution for that ,in future table will not go out of sync.

What's the reason behind this..We did setup accroding the oracle streams recommned.

Can you please help ?

Thanks in Advance.

Regards,
Singh

Report message to a moderator

Previous Topic:	Add_Subset_propagation_rules for BLOB data type
Next Topic:	stream between two different user name (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 12:55:42 CST 2024