OraFAQ Forum: Streams & AQ » Help with Oracle Streams. How to uniquely identify LCRs in queue?

Home » Server Options » Streams & AQ » Help with Oracle Streams. How to uniquely identify LCRs in queue?

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

Help with Oracle Streams. How to uniquely identify LCRs in queue? [message #622145]

Thu, 21 August 2014 07:23

referal1982
Messages: 1
Registered: August 2014
Location: Croatia

Junior Member

We are using strems for data replication in our shop.

When an error occours in our processing procedures, the LCR is moved to the error queue.

The problem we are facing is we don't know how to uniquely identify LCRs in that queue, so we can run them again when we think the error is corrected.

LCRs contain SCN, but as I understand it, the SCN is not unique.

What is the easy way to keep track of LCRs? Any information is helpful.

Thanks

Report message to a moderator

Re: Help with Oracle Streams. How to uniquely identify LCRs in queue? [message #622147 is a reply to message #622145]

Thu, 21 August 2014 07:39

John Watson
Messages: 8970
Registered: January 2010
Location: Global Village

Senior Member

Cross-posting,
https://community.oracle.com/message/12597561#12597561

Report message to a moderator

Re: Help with Oracle Streams. How to uniquely identify LCRs in queue? [message #622153 is a reply to message #622147]

Thu, 21 August 2014 11:20

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Even I found this topic posted in OTN, however, not all moderators here in OraFAQ appreciate when it is addressed in this fashion. I am completely clueless about it. Is it considered ethical to remind OP about cross posting in multiple forums? Because when I did so in past, I was replied sarcastically. I even shared it in community hangout forum once, I got mixed responses.

Report message to a moderator

Re: Help with Oracle Streams. How to uniquely identify LCRs in queue? [message #622156 is a reply to message #622153]

Thu, 21 August 2014 12:19

Michel Cadot
Messages: 68751
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no problem cross-posting.
It is interesting for us to have the link to this cross-post.
I think this is the purpose of John's post not to point OP to something wrong.
(Indeed I prefer to prefix the link by something like "for cross-ref" to prevent for misinterpretation.)

Report message to a moderator

Re: Help with Oracle Streams. How to uniquely identify LCRs in queue? [message #622157 is a reply to message #622156]

Thu, 21 August 2014 12:38

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Will take offline, probably via PM or suitable forum. I don't want to spoil this thread. For example : http://www.orafaq.com/forum/mv/msg/190888/604397/#msg_604397 Sorry for raising the concern here.

[Updated on: Thu, 21 August 2014 12:52]

Report message to a moderator

Previous Topic:	Dequeue with RETENTION on queue not working as expected with DELAY
Next Topic:	Oracle Streams

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 23:51:43 CDT 2025