Oracle Database Discussions

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!

Configuring CDC to capture from previous scn

731838Dec 8 2009

I am using 11g .

We have configured CDC(aynshronous hotlog) to capture changes from source db to staging db.

But due to some db issues the apply process vansihed and we need to reconfigure CDC from the scratch but the problem here is we are missing 3 days worth of data.

So will I be able to configure CDC to capture the source table changes from a scn which is 3 days back. From the CDC procedures I dont see a way of doing it and seems like only streams supports it. Any suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2010

Added on Dec 8 2009

#general-database-discussions

0 comments

443 views