| Log of Rejected LCRs in Stream Replication. [message #344781] |
Mon, 01 September 2008 04:27  |
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 #347170 is a reply to message #344781] |
Wed, 10 September 2008 23:12  |
varunvir
Messages: 389
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,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
