topic Re: Oracle CDC Error while reading archive redo log in Qlik Replicate

Oracle CDC Error while reading archive redo log

satyajit_ray — Thu, 19 Aug 2021 12:04:45 GMT

I am getting below error while reading oracle archive redo log file. Could you please guide me the root cause of the error and how to resolve the same in future.

[SOURCE_CAPTURE ]E: Cannot read 488 bytes from the file /dbanme/folder_name/attunity/1_17500000_xxxxxx.dbf. Stale file handle (errno '116') [20014] (oradcdc_io.c:256)

[SOURCE_CAPTURE ]E: Failed to read Redo log header [20014] (oradcdc_redo.c:106)

[SOURCE_CAPTURE ]E: Failed to read the header to validate the last written page [20014] (oradcdc_redo.c:1154)

Re: Oracle CDC Error while reading archive redo log

john_wang — Fri, 20 Aug 2021 02:18:36 GMT

Hello @satyajit_ray ,

Thanks for you contacting Qlik Support.

From the above messages seems to be an issue with a certain Redo Log we are trying to read from. Please make sure you are working with supported Oracle versions:

https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/Support%20Matrix/supported_source_endpoints.htm#Relation

As it looks more like an Oracle redo log file issue, please check with your DBA to see the state of this Redo log was and if they are able to do a DUMP Oracle Command on this file as shown below to validate the file:

SQL> alter system dump logfile '/dbanme/folder_name/attunity/1_17500000_xxxxxx.dbf' validate;

If you need additional assistance please provide:
1- the redo log file (compress it before transfer)
2- the task Diagnostics Packages with logging level source_capture set to Verbose
3- the 10 redo log files status and file sizes around seq #17500000 (eg between 17499995 and 17500005)
It's better you open a support case and attach above information for troubleshooting.

thank you,

John.

Re: Oracle CDC Error while reading archive redo log

satyajit_ray — Fri, 20 Aug 2021 13:52:52 GMT

Thank you @John . I will raise a support case incase we are not able to identify the root cause.

Re: Oracle CDC Error while reading archive redo log

Bill_Steinagle — Fri, 29 Jul 2022 20:37:52 GMT

Hello,

I also wanted to share the below DUMP command you can run on the Oracle Redo Log as this will validate the header and blocks that store the data. This is the command I used when debugging log issues.

From a SQL prompt connected to the Oracle Source environment:

SQL> alter system dump logfile '/dbanme/folder_name/attunity/1_17500000_xxxxxx.dbf validate;

Thanks!

Bill

Re: Oracle CDC Error while reading archive redo log

Dana_Baldwin — Fri, 12 Apr 2024 19:47:12 GMT

I can't find the case that was opened but did find this Oracle documentation on this error:

Access to File System is Denied Due to Stale File Handle (oracle.com)

Re: Oracle CDC Error while reading archive redo log

SushilKumar — Sun, 14 Apr 2024 06:32:04 GMT

Hello @satyajit_ray

Dana Suggestion may help to resolve the issue. You can also check post Redo is archived as an archive log. as redo are handled by Internal oracle process.

Regards,

Sushil Kumar