oracle cdc问题 Caused by: java.sql.SQLException: ORA-01289: cannot add duplicate logfile /opt/app/oracle/oradata/smsdb/o1_mf_8_dccd7nsy_.log #1420
Unanswered
MonsterChenzhuo
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
当create,同一个库下两个表时出现:
Caused by: org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42)
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:208)
at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:152)
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:119)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: ORA-01289: cannot add duplicate logfile /opt/app/oracle/oradata/smsdb/o1_mf_8_dccd7nsy_.log
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 1
Caused by: Error : 1289, Position : 0, Sql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME => '/opt/app/oracle/oradata/smsdb/o1_mf_8_dccd7nsy_.log', OPTIONS => DBMS_LOGMNR.ADDFILE);END;, OriginalSql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME => '/opt/app/oracle/oradata/smsdb/o1_mf_8_dccd7nsy_.log', OPTIONS => DBMS_LOGMNR.ADDFILE);END;, Error Msg = ORA-01289: cannot add duplicate logfile /opt/app/oracle/oradata/smsdb/o1_mf_8_dccd7nsy_.log
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 1
想请问社区,这是什么原因导致的?我要如何进行解决
Beta Was this translation helpful? Give feedback.
All reactions