Members   Search   Help    Register    Login   Home
Home » Server Options » Streams & AQ » Table not in sync in bi-directional streams replication (Oracle 10g)
Table not in sync in bi-directional streams replication [message #382492] Thu, 22 January 2009 11:32 Go to next message
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 Go to previous messageGo to next message
varunvir
Messages: 247
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
varunvir
Messages: 247
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 08:36:57 CST 2009

Total time taken to generate the page: 0.38901 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.