Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
Description
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