java.sql.SQLException: ORA-01291: missing log file

Issue

• java.sql.SQLException: ORA-01291: missing log file
• After restart the debezium connector, it fail after few hours with below error

Caused by: java.sql.SQLException: ORA-01291: missing log file
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 1

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1150)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:770)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:497)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:111)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1010)
        at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1530)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1310)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2162)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2117)
        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:327)
        at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1446)
        at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:556)
        at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:205)
        ... 9 more
Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '1111111', endScn => '1111112', 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 => '1111111', endScn => '1111112', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing log file
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 1