topic Re: Unable To Resume Logstream Task After Restoring Oracle Archive Log in Qlik Replicate

Unable To Resume Logstream Task After Restoring Oracle Archive Log

Raymond_C — Thu, 17 Jun 2021 17:05:54 GMT

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

Re: Unable To Resume Logstream Task After Restoring Oracle Archive Log

Madhavi_Konda — Thu, 17 Jun 2021 17:09:40 GMT

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

Re: Unable To Resume Logstream Task After Restoring Oracle Archive Log

lyka — Thu, 17 Jun 2021 17:14:30 GMT

Hello,

Please check this article:

https://community.qlik.com/t5/Knowledge-Base/Replicate-using-Oracle-source-fails-with-missing-redo-log/ta-p/1779064

Thanks

Lyka