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