How to determine if Oracle Redo Log is in error in Replicate

[Bill_Steinagle]

During the CDC process one may encounter a error with an Oracle Redo Log. To validate the Redo Log is not corrupt one can use the below command to DUMP the Oracle Redo Log that failed to open in Replicate. To do this run the command:

SQL> alter system dump logfile '/home/oracle/thread_redo_log_name.1035541595' validate;

Note: If there is an issue dumping the Redo Log it will show output as below and would require your Oracle DBA help as this shows problem with the file.

ERROR at line 1:
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 1589280 change 5977386357125 time
03/20/2020 10:25:15
ORA-00334: archived log: '/home/oracle/thread_1_seq_264614.10301.1035541595'

Environment

• Qlik Replicate 6.6, 7.0

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.