Home » Server Options » Streams & AQ » Oracle Streams (10g R2 Unix Env)
Oracle Streams [message #514092] Fri, 01 July 2011 07:15 Go to next message
TRaj
Messages: 80
Registered: September 2006
Member

Hi,


We use a uni-directional streams env involving 2 databases.

Need to know how the spilled msgs can be handled.

Will those msgs will be propagated and applied automatically?

How to handle failed transactions in the queues due to various errors with capture, propagation or apply processes.

In my application, we cannot re-execute the transactions at the source db if it got failed to replicate at the destination db.

Thanks.
Re: Oracle Streams [message #514101 is a reply to message #514092] Fri, 01 July 2011 08:16 Go to previous messageGo to next message
John Watson
Messages: 4390
Registered: January 2010
Location: Global Village
Senior Member
Hello - I think it may not be possible to answer such general questions here, but I'll try to give a few pointers.
First, by "spilled msgs" do you mean messages in a buffered queue that have been written to disc? If so, no worries - they will be propagated when possible. As for what you call "failed transactions", you must write your own message handlers to deal with them, certainly do not re-execute the transaction at the source.
Re: Oracle Streams [message #516655 is a reply to message #514092] Tue, 19 July 2011 21:20 Go to previous message
ssgottik
Messages: 3
Registered: January 2009
Junior Member
Hi ,

No need to wory much about spilled messages. Oracle will take care of it automatically.

Most offen you use to get ORA-01403 NO DATA FOUND error, below link may be useful for you to trouble shoot the above issue.

gssdba.wordpress.com/2011/05/09/ora-01403-no-data-found-in-oracle-streams/

Thanks and Regards,
Satish.G.S
gssdba.wordpress.com
Previous Topic: Oracle CDC - WAITING FOR REDO
Next Topic: NEW ORACLE STRAMS CONFIG
Goto Forum:
  


Current Time: Mon Jul 28 03:44:46 CDT 2014

Total time taken to generate the page: 0.09409 seconds