2024-11-28 12:21:26,396 INFO   Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Connected metrics set to 'false' [io.debezium.pipeline.ChangeEventSourceCoordinator]
2024-11-28 12:21:26,396 INFO   Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Finished streaming [io.debezium.pipeline.ChangeEventSourceCoordinator]
2024-11-28 12:21:26,396 INFO   Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Offsets: OracleOffsetContext [scn=131757643, commit_scn=["131757648:1:08000d00f77c0100"], lcr_position=null] [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource]
2024-11-28 12:21:26,396 INFO   Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Streaming metrics dump: LogMinerStreamingChangeEventSourceMetrics{connectorConfig=io.debezium.connector.oracle.OracleConnectorConfig@1ae6750a, startTime=2024-11-28T12:21:18.295045790Z, clock=SystemClock[Z], currentScn=131762232, offsetScn=null, commitScn=null, oldestScn=null, oldestScnTime=null, currentLogFileNames=[Ljava.lang.String;@176dacdb, redoLogStatuses=[Ljava.lang.String;@5abcd705, databaseZoneOffset=+08:00, batchSize=20000, logSwitchCount=0, logMinerQueryCount=0, sleepTime=2200, minimumLogsMined=1, maximumLogsMined=1, maxBatchProcessingThroughput=0, timeDifference=-1095, processedRowsCount=0, activeTransactionCount=0, rolledBackTransactionCount=0, oversizedTransactionCount=0, changesCount=0, scnFreezeCount=0, batchProcessingDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@5f01c663, fetchQueryDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@76e6a6ac, commitDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@c97c7df, lagFromSourceDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@30af2db7, miningSessionStartupDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@61ccd71f, parseTimeDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@22dcde4c, resultSetNextDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@10474cf7, userGlobalAreaMemory=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$MaxLongValueMetric@594c19dd, processGlobalAreaMemory=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$MaxLongValueMetric@5ebf59c4, abandonedTransactionIds=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$LRUSet@1a55c2e1, rolledBackTransactionIds=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$LRUSet@305f05a8} io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics@3fbafa67 [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource]
2024-11-28 12:21:26,396 INFO   Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] startScn=131757643, endScn=131762232 [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource]
2024-11-28 12:21:26,396 WARN   Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Retry 5 of 5 retries will be attempted [io.debezium.pipeline.ErrorHandler]
	... 24 more
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile
	at java.base/java.lang.Thread.run(Thread.java:1583)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617)
	at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
java.sql.SQLException: ORA-01291: missing logfile
2024-11-28 12:21:26,396 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Producer failure [io.debezium.pipeline.ErrorHandler]
	... 24 more
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile
	at java.base/java.lang.Thread.run(Thread.java:1583)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617)
	at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
java.sql.SQLException: ORA-01291: missing logfile
2024-11-28 12:21:26,396 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Mining session stopped due to error. [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource]
	... 24 more
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile
	at java.base/java.lang.Thread.run(Thread.java:1583)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617)
	at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
java.sql.SQLException: ORA-01291: missing logfile
2024-11-28 12:21:26,395 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Got exception when starting mining session. [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource]
2024-11-28 12:21:26,395 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] No logs were found with a status code of 4. [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter]
	... 24 more
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '131757644', endScn => '131762232', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile
	at java.base/java.lang.Thread.run(Thread.java:1583)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617)
	at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
java.sql.SQLException: ORA-01291: missing logfile
2024-11-28 12:21:26,395 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Failed to start Oracle LogMiner after '5' attempts. [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource]
2024-11-28 12:21:26,395 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] 	SCN: [131757644-131762233], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter]
2024-11-28 12:21:26,395 ERROR  Oracle|relation_cdc_server_1862083316347539458|streaming [debezium-oracleconnector-relation_cdc_server_1862083316347539458-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters:  [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter]