Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reinstantiation after manual resync

SujoyOct 5 2008 — edited Oct 13 2008

Hi All,

In my Streams setup, I have 8 sources(9i) and 1 destination(10g).
Due to a data file corruption, replication did not occur for some days.
I stopped all the capture and apply processes.
Then I have manually resynced the data by inserting/updating data only at the destination side.
Do I now need to reinstantiate the tables before I start the capture?

If I do need to reinstantiate, then do I also have to prepare the tables for instantiation and then set the SCN?

Thanks,
Sujoy

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2008

Added on Oct 5 2008

#performance-availability, #streams

8 comments

1,424 views