Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
SanjeevAsher
Partner - Contributor III
Partner - Contributor III

Oracle redo logs deleted - how to make replicate work

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.

1 Solution

Accepted Solutions
lyka
Support
Support

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

View solution in original post

2 Replies
lyka
Support
Support

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
Partner - Contributor III
Partner - Contributor III
Author

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