Home » Server Options » Streams & AQ » Log of Rejected LCRs in Stream Replication. (Oracle 10.2.0.1, Os: windows xp)
Log of Rejected LCRs in Stream Replication. [message #344781] Mon, 01 September 2008 04:27 Go to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hi Friends,

In Stream replication (Say schema level replication), If the change is made in primary database schema, and because of any reason, that change couldn't be applied to replica schema object, then where is it stored?
Does oracle maintains the list of such changes, which couldnot be applied (failed) on replica schema? From where can we get the list of such changes..?

Example: One record is changed on primary schema table, but that record is not exists on replica schema table. Then , replication of that change will be failed. From where can we get such records?

Regards,
Dipali..
Re: Log of Rejected LCRs in Stream Replication. [message #344976 is a reply to message #344781] Tue, 02 September 2008 01:21 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
Example: One record is changed on primary schema table, but that record is not exists on replica schema table. Then , replication of that change will be failed. From where can we get such records?


You should check your materialized view become valid/invalid.

Babu
Re: Log of Rejected LCRs in Stream Replication. [message #345051 is a reply to message #344976] Tue, 02 September 2008 03:50 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

I am not using materialized view for replication.
It is Stream Replication.

Regards,
Dipali..
Re: Log of Rejected LCRs in Stream Replication. [message #346102 is a reply to message #345051] Sat, 06 September 2008 00:47 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hi Friends,

Here is the Good solution..
http://www.acs.ilstu.edu/docs/Oracle/server.101/b10727/strms_mo.htm#1007895

Hope , this will help others..

Regards,
Dipali..
Re: Log of Rejected LCRs in Stream Replication. [message #347170 is a reply to message #344781] Wed, 10 September 2008 23:12 Go to previous messageGo to next message
varunvir
Messages: 330
Registered: November 2007
Senior Member
Oracle maintains all the captured records in its logminer
dictionary.You can query dba_lgmnr_log to get information about all the scns captured and applied.
If the record is not getting replicated then check
your alert logfile and see if the captured LCRS are applied.

Regards,
Varun Punj,
Re: Log of Rejected LCRs in Stream Replication. [message #348510 is a reply to message #347170] Wed, 17 September 2008 01:30 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Thanks Varun.
Previous Topic: Oracle Streaming
Next Topic: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS
Goto Forum:
  


Current Time: Fri Dec 19 15:25:11 CST 2014

Total time taken to generate the page: 0.19697 seconds