Skip to Main Content

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!

Setting the Start SCN for an Existing Capture Process doesn't work

LinoPistoJun 12 2017

Hello people

I am reading the documentation below

https://docs.oracle.com/cd/B28359_01/server.111/b28321/strms_mcap.htm#i1006494

but doesn't work to me.

I have 2 databases with some tables synchronized using bidirectional streams replication. both up and running with capture/apply/broadcast on each.

This is how I test:

1-  execute the following query in the destination db: SELECT a.applied_message_number FROM ALL_APPLY_PROGRESS A WHERE apply_name = 'my_streams_container';

result is number applied_message_number = '1234'

2- insert some records in source database

3- stop capture on the destination db, delete the previous inserted records on the destination db, the change is not applied on the source and i'm happy of this

4- on the source execute the following:

exec DBMS_CAPTURE_ADM.STOP_CAPTURE(capture_name  => 'my_streams_container');

exec DBMS_CAPTURE_ADM.ALTER_CAPTURE(capture_name => 'my_streams_container', start_scn => '1234');

exec dbms_capture_adm.start_CAPTURE(capture_name  => 'my_streams_container');

5- nothing happens on the destination, I was expecting to see again the records inserted on the step 2 and deleted on the step 3

do you have any suggestion?

thanks,

Massimo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2017
Added on Jun 12 2017
0 comments
360 views