文档首页/ 数据治理中心 DataArts Studio/ 常见问题/ 数据集成(实时作业)/ Oracle作为源端时,增量启动过程中报不支持CONTINOUS_MINE,关键字“oracle.jdbc.OracleDatabaseException: ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR”怎么办?
更新时间:2025-08-15 GMT+08:00
分享

Oracle作为源端时,增量启动过程中报不支持CONTINOUS_MINE,关键字“oracle.jdbc.OracleDatabaseException: ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR”怎么办?

问题描述

Oracle作为源端时,增量启动过程中报不支持CONTINOUS_MINE,jobmanager或者task manager日志报错“oracle.jdbc.OracleDatabaseException: ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR”。

ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 1
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at org.apache.inlong.sort.cdc.oracle.shaded.io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1446) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at org.apache.inlong.sort.cdc.oracle.shaded.io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:678) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at org.apache.inlong.sort.cdc.oracle.shaded.io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:240) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at org.apache.inlong.sort.cdc.oracle.source.reader.fetch.OracleStreamFetchTask$RedoLogSplitReadTask.execute(OracleStreamFetchTask.java:136) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at org.apache.inlong.sort.cdc.oracle.source.reader.fetch.OracleStreamFetchTask.execute(OracleStreamFetchTask.java:74) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at org.apache.inlong.sort.cdc.oracle.shaded.org.apache.inlong.sort.cdc.base.source.reader.external.IncrementalSourceStreamFetcher.lambda$submitTask$0(IncrementalSourceStreamFetcher.java:86) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_412]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_412]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_412]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_412]
    at java.lang.Thread.run(Thread.java:750) [?:1.8.0_412]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR.
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 1
 
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[blob_p-ae195b90d37a40e645add451c65120a442900059-4727c0614178dd3ac7cfd9e4530f3d8b:?]
    ... 23 more

原因分析

Oracle 19c不支持CONTINOUS_MINE选项读取日志,该选项用于logimner读取日志的过程中自动加载新增加的日志。

解决方案

在作业的自定义配置选项中关闭CONTINOUS_MINE选项, 设置如下:

debezium.log.mining.continuous.mine         false

相关文档