Oracle streams - waiting for redo when the redo file is gone forever

Question

I have streams configured, which stopped working after a while. To resync, I stopped all capture/apply processes and exported the tables from source to target.

After starting up again, it still says waiting for that same redo file.

Is it possible to "restart" streams from a current file?

Answer 1

Do you want to "shift" your capture process ahead in time? You could try to switch your capture process to a certain SCN by invoking

DBMS_CAPTURE_ADM.ALTER_CAPTURE('YOUR_CAPTURE_NAME', start_scn => :SCN);

where :SCN is a valid system change number from which you want your messages to be captured. Take a look at DBMS_CAPTURE_ADM description.