Error: F_JT0400: Log Scanning Error F_JZ117C

Issue

A Capture job for an Oracle source fails with the following error:

F_JT0400: Log scanning error F_JZ117C. Unable to find a redo/archive log by resetlogs_id=<resetlogs_id> and sequence#=<sequence> (thread 1).

Querying v$archived_log returns no rows for the expected resetlogs_id.

Environment

• HVR 6
• Source: Oracle

Resolution

To resolve this issue:

1. Refresh your HVR channel.
2. Verify the current database incarnation:

   SELECT * FROM v$database_incarnation;
   

   Confirm that the current resetlogs_id matches the source database.
3. Confirm that the expected logs are archived:

   SELECT SEQUENCE#, blocks FROM v$ARCHIVED_LOG WHERE thread# = 1 AND resetlogs_id = <resetlogs_id>;
   

4. If the issue persists, contact our support team and provide the Oracle Alert logs and HVR capture state.

Cause

This issue occurs when the Oracle source database is opened with OPEN RESETLOGS, such as after a point-in-time recovery, Data Guard failover, or flashback operation. OPEN RESETLOGS creates a new database incarnation, which invalidates the HVR log position.