-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
Hi team
We are using debezium server 1.8 version, which is connecting to oracle database(12C enterprise). we are following bellow sequence
1) Debezium is installed on top of GCP- compute engine machine - e2standard4
2) Debezium is able to establish the connectivity with oracle db (10.6.63.198)
3) but considering "source.log.mining.archive.log.only.mode=true" property - to read archive logs only, we are getting ORA-01291: missing logfile issues.
4) While running with "source.log.mining.archive.log.only.mode=true" property we are able to get backfill data, but once it starts for streaming , it throws the ORA-01291: missing logfile errors.
observations:
1) If we run with redo+archive i.e "source.log.mining.archive.log.only.mode=false" property, our debezium CDC pipeline working fine.
2) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126133316324', endScn => '126133324126', 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 => '126133316324', endScn => '126133324126', 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
As per above error we can see it reads SCN from DICT_FROM_REDO_LOGS (redo log), which is not correct as we are trying to read data from archive logs.
please help us to resolve issue
please find the following configuration details
connector.class = io.debezium.connector.oracle.OracleConnector
database.history.file.filename = tempiposct2v16/FileDatabaseHistory.dat
database.user = DBZUSER
database.dbname = AMCTPRD
key.converter.value = json
database.server.name = AMCTPRD
database.port = 1521
value.converter.value = json
offset.flush.interval.ms = 0
tombstones.on.delete = false
offset.storage.file.filename = tempiposct2v16/offsets.dat
decimal.handling.mode = double
database.hostname = 10.6.63.198
name = pubsub
log.mining.archive.log.only.mode = true
database.oracle.version = 12+
table.include.list = TOS_USR.CTRDTLS_O,TOS_USR.CTROTHDTLS
value.converter.key = json
database.history = io.debezium.relational.history.FileDatabaseHistory
snapshot.mode = schema_only
key.converter.key = json