Unable to resume a log streaming task after adding new tables
We have setup a log steam successfully. Then I stopped all the child tasks before stopping the main parent log streaming task. Thereafter, we added new tables into the log streaming and click resume.
Upon trying to start the task failed to start. We got the following error.
Stream component 'st_0_serverA' terminated Stream component failed at subtask 0, component st_0_serverA Error executing command Failed to set stream position on context '00000000.800fe001.00000001.00b5.00.0000:818279.480556.16' The provided scn 00000000800FE001 is not found in Redo log, thread 1
Hmm, that should have worked. I was wondering whether this could have been a 'edge' condition where the SCN was expected in a REDO l og but had move to become an Archived Log and the redolog overwritten again? Did you just try again ? Did you recover using start by timestamp?
Can you determine where that SCN should have been at the time of execution?
Check with queries like
select * from v$log_history where first_time > sysdate - 5;
select to_char(first_time, 'yyyy-mm-dd HH24:MI:SS'), first_change#, name from v$archived_log where first_time > sysdate - 5;
select scn_wrp, scn_bas, to_char(time_dp, 'yyyy-mm-dd HH24:MI:SS') from SMON_SCN_TIME where time_dp > sysdate - 1 order by time_dp;
Instead of the sysdate - x you want to use time ranges relevant to the issue.
