topic Re: Oracle redo logs deleted - how to make replicate work in Qlik Replicate

Oracle redo logs deleted - how to make replicate work

SanjeevAsher — Thu, 12 Aug 2021 18:10:33 GMT

The Oracle redo/archive logs were deleted by the DBA as the file system was full. Now Replicate is not able to perform CDC and we are getting the Error "ora-22288 file or lob operation getlength failed no such file or directory"

How to recover from this situation and resume CDC. Since the redo/archive logs were deleted there is no way to recover the logs.

Re: Oracle redo logs deleted - how to make replicate work

lyka — Thu, 12 Aug 2021 18:13:37 GMT

Hi Sanjeev,

Please refer to this article in our community about errors when redo logs are missing.

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

You mentioned that there is no way for your to recover the redo logs. If that is the case and redo logs cannot be restored then you need to do a RELOAD of the task

Thansk

Lyka

Re: Oracle redo logs deleted - how to make replicate work

SanjeevAsher — Thu, 12 Aug 2021 19:06:48 GMT

Hi Lyka,

Thanks for quick revert. Unfortunately we don't have an option to RELOAD the tasks as we have billions of records. Figured out a way to point to the latest redo log so that Replicate can resume. For the missing data we will figure out a way to reload it from the source system.

-thanks

Sanjeev

Re: Oracle redo logs deleted - how to make replicate work

FrancoHR — Tue, 13 Jun 2023 20:09:56 GMT

Hello @SanjeevAsher

How did you resume the task from the last record? How do you know what was the last record in the logstream task?

Regards,