Long stream of redo thread inconsistencies blocks mining

## Bug report

**What Debezium connector do you use and what version?**

Oracle 3.4.0.Final

---

**What is the connector configuration?**

n/a

---

**What is the captured database version and mode of deployment?**

_E.g. on-premises, with a specific cloud provider, etc._

Oracle Exascale 23ai

---

**What behavior do you expect?**

The connector to be reliable during scale up/down of Oracle resources (ECPUs, etc.)

---

**What behavior do you see?**

When Exascale scales up or down specific nodes, processes that `ARC` will become blocked because, during a scale-down, there may be a short period when more processes need resources than resources are available. This can lead to an unfortunate stream of redo thread is inconsistent messages:
```
2026-02-03 19:44:05.814
2026-02-03T18:44:05,814 INFO Redo Thread 2 is inconsistent; failed to find log with sequence 24426 (io.debezium.connector.oracle.logminer.LogFileCollector) [debezium-oracleconnector-cdc_ora_avro-change-event-source-coordinator]
2026-02-03 19:44:05.815
io.debezium.DebeziumException: Redo Thread 2 is inconsistent; failed to find log with sequence 24426
2026-02-03 19:44:08.138
2026-02-03T18:44:08,138 INFO Redo Thread 2 is inconsistent; failed to find log with sequence 24426 (io.debezium.connector.oracle.logminer.LogFileCollector) [debezium-oracleconnector-cdc_ora_avro-change-event-source-coordinator]
2026-02-03 19:44:08.138
io.debezium.DebeziumException: Redo Thread 2 is inconsistent; failed to find log with sequence 24426
2026-02-03 19:44:11.285
2026-02-03T18:44:11,285 INFO Redo Thread 2 is inconsistent; failed to find log with sequence 24426 (io.debezium.connector.oracle.logminer.LogFileCollector) [debezium-oracleconnector-cdc_ora_avro-change-event-source-coordinator]
2026-02-03 19:44:11.285
io.debezium.DebeziumException: Redo Thread 2 is inconsistent; failed to find log with sequence 24426
2026-02-03 19:44:16.086
2026-02-03T18:44:16,086 INFO Redo Thread 2 is inconsistent; failed to find log with sequence 24426 (io.debezium.connector.oracle.logminer.LogFileCollector) [debezium-oracleconnector-cdc_ora_avro-change-event-source-coordinator]
2026-02-03 19:44:16.086
io.debezium.DebeziumException: Redo Thread 2 is inconsistent; failed to find log with sequence 24426
```

---

**Do you see the same behaviour using the latest released Debezium version?**

_Ideally, also verify with the latest Alpha/Beta/CR version._

Yes

---

**Do you have the connector logs, ideally from start till finish?**

_You might be asked later to provide [DEBUG/TRACE](https://debezium.io/documentation/reference/stable/operations/logging.html) level log._

Provided in https://debezium.zulipchat.com/#narrow/channel/348250-community-oracle/topic/Oracle.20Exascale.2023ai.20-.20ORA-01291.3A.20missing.20log.20file/near/572138488

---

**How to reproduce the issue using our [tutorial](https://github.com/debezium/debezium-examples/tree/main/tutorial) deployment?**

n/a