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
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: 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,
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.
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: 389
Registered: November 2007
Senior Member
Then check the errors and resolve them to make data in sync.
Regards,
Varun Punj,
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
Previous Topic: Add_Subset_propagation_rules for BLOB data type
Next Topic: stream between two different user name (merged)
Goto Forum:
  


Current Time: Thu Mar 28 18:51:00 CDT 2024