| Schema Stream replication have Error ORA-26687: no instantiation SCN provided [message #400697] |
Wed, 29 April 2009 05:35 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
I am using Bidirectional Stream Schema Replication,
From production ----->Destination Server
From Destination----->Production Server
We have been using this Replication for more than 6 months. But yesterday i get the following Apply error in Destination site
ORA-26687: no instantiation SCN provided for "prod"."transacions"
The above table was visible in dba_capture_prepared_tables view on production site previously, but it is not visible now, i could not find the reason how it is not initiated when there is no ddl on production site.
I check the errors the insertion in the same table was the main cause of this problem.
Now i want to find out that how do i sync whole schema in destination with Production database as the apply process Aborted and most of the tables are out of sync with Production on other hand replication from destination to Production is working fine (We are not using Destination database for insertion or update of any record), insert and update is only on Production.
That is why i am worried about the replication from production to destination server.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
