Oracle redo logs deleted - how to make replicate work

[SanjeevAsher]

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.

[lyka · Accepted solution]

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...

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

[SanjeevAsher]

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

[FrancoHR]

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,