oracle CDC error ORA-01291: missing logfile

asked 2021-08-18 08:35:44 -0500

AC gravatar image

updated 2021-08-19 03:34:48 -0500

Hello, I have an issue for a while. Im using Oracle CDC origin to read data from online catalog, but I started to get error the error above (ORA-01291). For this problem , I read the blog link text . In summary, As I understand, to reset offset could be a solution. I applied to start with reset origin. I saw that Missing records came into my destination table. However, next day I recognized that some records are also missing without giving any error.

Nearly 7 hours ago , I started pipeline with reset origin, I started to see missing data comes too.

Is there any way to handle this situtation ? I mean, without resetting offset for each I recognized the missing data , could a solution be for the issue?

Streamsets version : StreamSets Data Collector 3.18.1 Oracle driver : ojdbc8.jar

Regards

Note :

Regarding to this error, I found details in the log below.

ERROR LogMinerSession - Could not add redo log file to LogMiner: $(filename), seq: 1/10171, start: 409194415 (2021-08-18T20:00:27), end: 409274352 (2021-08-18T21:00:33), dictionary: no java.sql.SQLException: ORA-01284: file $(filename) cannot be opened ORA-00308: cannot open archived log '$(filename)' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 ORA-06512: at "SYS.DBMS_LOGMNR", line 82 ORA-06512: at line 1

edit retag flag offensive close merge delete