Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Raymond_C
Contributor
Contributor

Unable To Resume Logstream Task After Restoring Oracle Archive Log

When trying to resume a Logstream task after restoring an archive log file, the task is returning an error:

"Archived Redo log with the sequence 345625 does not exist, thread 1 [1022318] (oradcdc_thread.c:595)"

The log file was restored using Oracle RMAN and is visible in the Unix filesystem but Replicate cannot seem to see it. We can't see anything obvious in the Attunity logs and our Oracle\Unix guys have checked that permissions etc. are still ok.

The support team are looking at this for us but was wondering if anyone else came across similar issues and if so, did you manage to resolve them?


Thanks,
Raymond

Labels (2)
1 Solution
2 Replies
Madhavi_Konda
Support
Support

Hi Raymond,
Replciate queries v$archived_log for the existence of the archived redo logs. Can you please verify with the following query?
select NAME,DEST_ID,THREAD#,SEQUENCE#,ARCHIVED,DELETED,status from v$archived_log where SEQUENCE#=345625;
Please check the dest_id given here is matching with your end point destination id.

Thanks,
Madhavi