Unable To Resume Logstream Task After Restoring Oracle Archive Log

[Raymond_C]

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

[Madhavi_Konda]

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

[lyka · Accepted solution]

Hello,

Please check this article:

https://community.qlik.com/t5/Knowledge-Base/Replicate-using-Oracle-source-fails-with-missing-redo-l...

Thanks

Lyka