__ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2022-03-16 13:00:33,897 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$207/0x000000084023c840@36a7abe1' stream name mapper 2022-03-16 13:00:34,058 INFO [io.deb.ser.pub.PubSubChangeConsumer] (main) Using default PublisherBuilder 'io.debezium.server.pubsub.PubSubChangeConsumer$$Lambda$217/0x0000000840266840@21fff664' 2022-03-16 13:00:34,058 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.pubsub.PubSubChangeConsumer' instantiated 2022-03-16 13:00:34,205 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-03-16 13:00:34,209 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2022-03-16 13:00:34,223 INFO [io.deb.emb.EmbeddedEngine$EmbeddedConfig] (main) EmbeddedConfig values: access.control.allow.methods = access.control.allow.origin = admin.listeners = null bootstrap.servers = [localhost:9092] client.dns.lookup = use_all_dns_ips config.providers = [] connector.client.config.override.policy = All header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter key.converter = class org.apache.kafka.connect.json.JsonConverter listeners = [http://:8083] metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 offset.flush.interval.ms = 0 offset.flush.timeout.ms = 5000 offset.storage.file.filename = tempiposct2v21/offsets.dat offset.storage.partitions = null offset.storage.replication.factor = null offset.storage.topic = plugin.path = null response.http.headers.config = rest.advertised.host.name = null rest.advertised.listener = null rest.advertised.port = null rest.extension.classes = [] ssl.cipher.suites = null ssl.client.auth = none ssl.enabled.protocols = [TLSv1.2, TLSv1.3] ssl.endpoint.identification.algorithm = https ssl.engine.factory.class = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.certificate.chain = null ssl.keystore.key = null ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLSv1.3 ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.certificates = null ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS task.shutdown.graceful.timeout.ms = 5000 topic.creation.enable = true topic.tracking.allow.reset = true topic.tracking.enable = true value.converter = class org.apache.kafka.connect.json.JsonConverter 2022-03-16 13:00:34,223 WARN [org.apa.kaf.con.run.WorkerConfig] (main) The worker has been configured with one or more internal converter properties ([internal.key.converter, internal.value.converter]). Support for these properties was deprecated in version 2.0 and removed in version 3.0, and specifying them will have no effect. Instead, an instance of the JsonConverter with schemas.enable set to false will be used. For more information, please visit http://kafka.apache.org/documentation/#upgrade and consult the upgrade notesfor the 3.0 release. 2022-03-16 13:00:34,223 WARN [org.apa.kaf.con.run.WorkerConfig] (main) Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results. 2022-03-16 13:00:34,227 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-03-16 13:00:34,228 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-03-16 13:00:34,231 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2022-03-16 13:00:34,246 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file tempiposct2v21/offsets.dat 2022-03-16 13:00:34,381 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 13:00:34,384 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 13:00:34,385 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v21/FileDatabaseHistory.dat 2022-03-16 13:00:34,385 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 13:00:34,385 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 13:00:34,386 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 13:00:34,386 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 13:00:34,386 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 13:00:34,387 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 13:00:34,387 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 13:00:34,387 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 13:00:34,387 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v21/offsets.dat 2022-03-16 13:00:34,387 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 13:00:34,388 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 13:00:34,388 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 13:00:34,388 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 13:00:34,388 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 13:00:34,389 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 13:00:34,390 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 13:00:34,391 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 13:00:34,392 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 13:00:34,393 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2022-03-16 13:00:34,393 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 13:00:34,499 INFO [io.quarkus] (main) debezium-server-dist 1.8.0.Final on JVM (powered by Quarkus 2.5.0.Final) started in 2.613s. Listening on: http://0.0.0.0:7071 2022-03-16 13:00:34,500 INFO [io.quarkus] (main) Profile prod activated. 2022-03-16 13:00:34,501 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health, vertx] 2022-03-16 13:00:35,534 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 13:00:35,714 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) No previous offsets found 2022-03-16 13:00:35,715 INFO [io.deb.con.ora.OracleConnectorTask] (pool-7-thread-1) Connector started for the first time, database history recovery will not be executed 2022-03-16 13:00:35,732 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 13:00:35,733 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 13:00:35,745 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 13:00:35,746 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 13:00:35,751 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No previous offset has been found. 2022-03-16 13:00:35,751 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) According to the connector configuration only schema will be snapshot. 2022-03-16 13:00:35,752 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 1 - Preparing 2022-03-16 13:00:35,752 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 2 - Determining captured tables 2022-03-16 13:00:46,767 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 3 - Locking captured tables [AMCTPRD.TOS_USR.VOYCTRDTLS_O] 2022-03-16 13:00:46,820 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 4 - Determining snapshot offset 2022-03-16 13:00:46,884 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No latest table SCN could be resolved, defaulting to current SCN 2022-03-16 13:00:46,921 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 5 - Reading structure of captured tables 2022-03-16 13:00:54,020 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 6 - Persisting schema history 2022-03-16 13:00:54,738 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 7 - Skipping snapshotting of data 2022-03-16 13:00:54,762 INFO [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot - Final stage 2022-03-16 13:00:54,762 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=126219014491]] 2022-03-16 13:00:54,767 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 13:00:54,768 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 13:00:54,777 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 1 records sent during previous 00:00:20.502, last recorded offset: {snapshot=true, scn=126219014491, snapshot_completed=false} 2022-03-16 13:00:55,323 WARN [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting SCN 126219014491 is not yet in archive logs, waiting for archive log switch. 2022-03-16 13:02:53,346 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting SCN 126219014491 is now available in archive logs, log mining unpaused. 2022-03-16 13:04:07,972 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2 records sent during previous 00:03:13.195, last recorded offset: {commit_scn=126219027363, transaction_id=null, scn=126219027235} 2022-03-16 13:04:12,323 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:04:12,326 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:04:12,326 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:04:12,327 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126219055489, endScn=126219067727 2022-03-16 13:04:12,328 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126219067727, oldestScn=-1, committedScn=126219055487, offsetScn=126219034489, logMinerQueryCount=2, totalProcessedRows=12239, totalCapturedDmlCount=2, totalDurationOfFetchingQuery=PT3.51286S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT1.615415S, maxCapturedDmlCount=2, maxDurationOfFetchingQuery=PT1.897445S, totalBatchProcessingDuration=PT58.327002S, lastBatchProcessingDuration=PT2.120691S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | CURRENT], switchCounter=1563, batchSize=21000, millisecondToSleepBetweenMiningQuery=800, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.001585S, totalStartLogMiningSessionDuration=PT33.09737S, lastStartLogMiningSessionDuration=PT0.059792S, maxStartLogMiningSessionDuration=PT33.037578S, totalProcessTime=PT58.327002S, minBatchProcessTime=PT2.120691S, maxBatchProcessTime=PT56.206311S, totalResultSetNextTime=PT0.002266S, lagFromTheSource=DurationPT1M18.025188S, maxLagFromTheSourceDuration=PT3M20.702028S, minLagFromTheSourceDuration=PT1M18.023994S, lastCommitDuration=PT0.000002S, maxCommitDuration=PT0.014316S, activeTransactions=1, rolledBackTransactions=17, committedTransactions=6101, abandonedTransactionIds=[], rolledbackTransactionIds=[1c0004005e591000, 11002100886d2f00, 09001600ebf84a00, 02001600eae94000, 01000800d1fd4500, 26001800a7550100, 06002100d6f23400, 14001b00b5843100, 09001e008af84a00, 08000500be144300, 150011006f772900, 090002004ef94a00, 030005008ffe3900, 29000e00c1800000, 1d00030019b20e00, 250008005bd20100, 07000100d8d53800], registeredDmlCount=2, committedDmlCount=2, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=13604944, miningSessionUserGlobalAreaMaxMemory=25142848, miningSessionProcessGlobalAreaMemory=42103560, miningSessionProcessGlobalAreaMaxMemory=42103560} 2022-03-16 13:04:12,328 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126219055488] 2022-03-16 13:04:12,328 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 13:04:12,328 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 13:04:12,714 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 13:04:12,746 INFO [io.deb.jdb.JdbcConnection] (pool-11-thread-1) Connection gracefully closed 2022-03-16 13:04:12,749 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219055489', endScn => '126219067727', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:04:12,750 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:04:14,752 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:04:16,753 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:04:18,753 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:04:20,754 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:04:22,755 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v21/FileDatabaseHistory.dat 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 13:04:22,756 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v21/offsets.dat 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2022-03-16 13:04:22,757 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 13:04:23,136 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 13:04:23,175 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126219027235] 2022-03-16 13:04:23,176 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 13:04:23,191 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 14 ms 2022-03-16 13:04:23,193 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 13:04:23,193 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 13:04:23,195 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 13:04:23,195 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 13:04:23,195 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 13:04:23,197 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126219027235]] 2022-03-16 13:04:23,199 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 13:04:23,200 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming ANTLR Tool version 4.8 used for code generation does not match the current runtime version 4.9.2 ANTLR Runtime version 4.8 used for parser compilation does not match the current runtime version 4.9.2 ANTLR Tool version 4.8 used for code generation does not match the current runtime version 4.9.2 ANTLR Runtime version 4.8 used for parser compilation does not match the current runtime version 4.9.2 2022-03-16 13:06:13,414 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2 records sent during previous 00:02:05.442, last recorded offset: {commit_scn=126219109297, transaction_id=null, scn=126219090209} 2022-03-16 13:06:14,309 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:06:14,309 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:06:14,311 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:06:14,312 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126219113229, endScn=126219120813 2022-03-16 13:06:14,312 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126219120813, oldestScn=126219095645, committedScn=126219113221, offsetScn=126219090209, logMinerQueryCount=4, totalProcessedRows=37308, totalCapturedDmlCount=2, totalDurationOfFetchingQuery=PT21.772682S, lastCapturedDmlCount=2, lastDurationOfFetchingQuery=PT2.178706S, maxCapturedDmlCount=2, maxDurationOfFetchingQuery=PT12.434844S, totalBatchProcessingDuration=PT1M26.326219S, lastBatchProcessingDuration=PT8.928534S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | CURRENT], switchCounter=1575, batchSize=23000, millisecondToSleepBetweenMiningQuery=400, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.000438S, totalStartLogMiningSessionDuration=PT32.40141S, lastStartLogMiningSessionDuration=PT0.081164S, maxStartLogMiningSessionDuration=PT32.200006S, totalProcessTime=PT1M26.326219S, minBatchProcessTime=PT8.928534S, maxBatchProcessTime=PT50.985686S, totalResultSetNextTime=PT11.116833S, lagFromTheSource=DurationPT1M39.429827S, maxLagFromTheSourceDuration=PT4M16.497687S, minLagFromTheSourceDuration=PT1M39.429592S, lastCommitDuration=PT0.000001S, maxCommitDuration=PT0.026682S, activeTransactions=4, rolledBackTransactions=55, committedTransactions=18416, abandonedTransactionIds=[], rolledbackTransactionIds=[11002100886d2f00, 29001400be800000, 02001e007de94000, 08001000ff144300, 09001f00c5f94a00, 150011006f772900, 1c000c007c591000, 250008005bd20100, 010004001bfe4500, 07000100d8d53800, 05001e005ca32b00, 09001600fbf84a00, 09000c00a6f84a00, 0c002100f4a32300, 02001600eae94000, 0900020065f94a00, 28002000f99b0000, 0900140058f84a00, 29000e00c1800000, 09001c00bef84a00, 0900060025f84a00, 1d00030019b20e00, 09001700ecf84a00, 2500100054d20100, 1c0004005e591000, 0100070074fe4500, 01000800d1fd4500, 26001800a7550100, 09000500fdf84a00, 06002100d6f23400, 03001900e0fe3900, 0c001400f2a32300, 0900110029f84a00, 07000200abd43800, 07000700a7d53800, 0900040031f94a00, 09001e00a1f84a00, 02000a007dea4000, 1b00080098f71800, 09001600ebf84a00, 27000a00aed30000, 230015007a610900, 090012004bf84a00, 09001e008af84a00, 08000500be144300, 090002004ef94a00, 030005008ffe3900, 09001d0073f84a00, 060012001ff33400, 1d000600e8b10e00, 2300080054610900, 29002000b9800000, 060006005cf23400, 2300120079610900, 09000300ddf84a00], registeredDmlCount=2, committedDmlCount=2, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7733144, miningSessionUserGlobalAreaMaxMemory=18125008, miningSessionProcessGlobalAreaMemory=32469768, miningSessionProcessGlobalAreaMaxMemory=32469768} 2022-03-16 13:06:14,312 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126219095644] 2022-03-16 13:06:14,313 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 13:06:14,313 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 13:06:14,620 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 13:06:14,648 INFO [io.deb.jdb.JdbcConnection] (pool-12-thread-1) Connection gracefully closed 2022-03-16 13:06:14,649 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219113229', endScn => '126219120813', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:06:14,650 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:06:16,650 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:06:18,651 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:06:20,652 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:06:22,652 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:06:24,654 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 13:06:24,654 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v21/FileDatabaseHistory.dat 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v21/offsets.dat 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 13:06:24,655 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2022-03-16 13:06:24,656 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 13:06:24,981 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 13:06:25,011 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126219090209] 2022-03-16 13:06:25,011 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 13:06:25,015 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 3 ms 2022-03-16 13:06:25,016 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 13:06:25,016 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 13:06:25,018 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 13:06:25,019 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 13:06:25,019 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 13:06:25,019 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126219090209]] 2022-03-16 13:06:25,019 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 13:06:25,020 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 13:08:14,435 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:08:14,435 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:08:14,436 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:08:14,436 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126219176204, endScn=126219187428 2022-03-16 13:08:14,436 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126219187428, oldestScn=126219095645, committedScn=126219176204, offsetScn=126219095644, logMinerQueryCount=4, totalProcessedRows=40433, totalCapturedDmlCount=7, totalDurationOfFetchingQuery=PT20.58914S, lastCapturedDmlCount=3, lastDurationOfFetchingQuery=PT1.975385S, maxCapturedDmlCount=3, maxDurationOfFetchingQuery=PT9.063654S, totalBatchProcessingDuration=PT1M25.204246S, lastBatchProcessingDuration=PT2.479539S, maxBatchProcessingThroughput=1, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | CURRENT], switchCounter=1587, batchSize=23000, millisecondToSleepBetweenMiningQuery=400, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.001187S, totalStartLogMiningSessionDuration=PT33.003434S, lastStartLogMiningSessionDuration=PT0.050501S, maxStartLogMiningSessionDuration=PT32.848298S, totalProcessTime=PT1M25.204246S, minBatchProcessTime=PT2.479539S, maxBatchProcessTime=PT1M3.412619S, totalResultSetNextTime=PT6.926513S, lagFromTheSource=DurationPT1M44.57455S, maxLagFromTheSourceDuration=PT3M31.795004S, minLagFromTheSourceDuration=PT1M44.574374S, lastCommitDuration=PT0.000001S, maxCommitDuration=PT0.001418S, activeTransactions=3, rolledBackTransactions=40, committedTransactions=15435, abandonedTransactionIds=[], rolledbackTransactionIds=[1d00000009b20e00, 0900000081f94a00, 09000c00eef84a00, 0900070070f84a00, 0200020017ea4000, 29000c00db800000, 09001b0079f94a00, 02002000e5e84000, 0300080084fe3900, 27001c00bed30000, 0c001400f2a32300, 080010000f154300, 29001300dc800000, 090019005bf94a00, 1c0013007d591000, 0b000000ea7b1d00, 0f001a0017683000, 1b001b0088f71800, 1b001000a7f71800, 070019008ad53800, 230005007c610900, 09000a006ef94a00, 080001004a144300, 09000100e2f84a00, 29000200ce800000, 1c000b0096591000, 0900050044f94a00, 09000f00cef84a00, 09001c000af94a00, 06000400bef23400, 1300000039472d00, 0500090050a32b00, 03001d00c0fe3900, 0100130052fe4500, 2400010020310400, 26001c0083550100, 24000600f5300400, 28001500ff9b0000, 0500030058a12b00, 09000f00f3f84a00], registeredDmlCount=7, committedDmlCount=6, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7733088, miningSessionUserGlobalAreaMaxMemory=18092584, miningSessionProcessGlobalAreaMemory=29651720, miningSessionProcessGlobalAreaMaxMemory=29651720} 2022-03-16 13:08:14,436 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126219095644] 2022-03-16 13:08:14,436 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 13:08:14,436 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 13:08:14,653 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 13:08:14,676 INFO [io.deb.jdb.JdbcConnection] (pool-13-thread-1) Connection gracefully closed 2022-03-16 13:08:14,677 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126219176204', endScn => '126219187428', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 13:08:14,678 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:08:16,679 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:08:18,680 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:08:20,681 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:08:22,682 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 13:08:24,683 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 13:08:24,683 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 13:08:24,683 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v21/FileDatabaseHistory.dat 2022-03-16 13:08:24,683 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v21/offsets.dat 2022-03-16 13:08:24,684 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2022-03-16 13:08:24,685 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 13:08:25,011 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 13:08:25,044 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126219095644] 2022-03-16 13:08:25,044 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 13:08:25,049 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 4 ms 2022-03-16 13:08:25,051 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 13:08:25,052 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 13:08:25,053 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 13:08:25,053 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 13:08:25,053 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 13:08:25,054 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126219095644]] 2022-03-16 13:08:25,054 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 13:08:25,054 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming