Oracle CDC Error while reading archive redo log

[satyajit_ray]

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)

[john_wang]

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

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.

[satyajit_ray]

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

[Bill_Steinagle]

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

[Dana_Baldwin]

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)

[SushilKumar]

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