Oracle CDC - Not fetching any data due to missing Redo Log files for Time Range

  • 22 May 2023
  • 1 reply

We are using Streamsets CDC stage for fetching Oracle CDC Data. We are received error like, Missing redo log files for time range and pipeline is not fetching any data for long.


  1. What is the reason for receiving missing redo log error?
  2. What step need to take when we receive this kind of error?

1 reply

Userlevel 2

Redo logs get rotated, archived, backed-up and deleted automatically in an standard Oracle setup. This means that redo log are not always available for old data. In general terms, you should make sure you are ingesting a time range still available in redo logs. If unsure, you can query view v$log and v$archived_log, and check then columns first_time and next_time. At first glance, it looks as if you are trying to ingest data “too” old in terms of redo logs lifecycle.