A --> B --> Streamsets (Kudu)
A:
Solaris 11.4
Oracle DB 12.1.0.2
B:
Solaris 11.4
Oracle DB 12.1.0.2
Replication from A to B is Oracle Golden Gate(table replication) downstream. Redo logs are shipped from A to B and mined at B.
Hello Team,
good morning.
I would like some help on Oracle CDC. We are using Streamsets as CDC tool. Error below is obtained when starting replication.
2020-09-30 13:26:28,317OracleCDC_DWAREINIT2/OracleCDC85d1106b-977a-4042-baeb-5740ddc7afa4ERRORCould not add redo log file to LogMiner: dwaredr, seq: 2/48871, start: 296680559164 (2020-09-30T13:19:02), end: 296681215962 (2020-09-30T13:26:17), dictionary: noLogMinerSession*roshanbProductionPipelineRunnable-OracleCDC85d1106b-977a-4042-baeb-5740ddc7afa4-OracleCDC_DWAREINIT2java.sql.SQLException: ORA-01284: file dwaredr cannot be opened
ORA-00308: cannot open archived log 'dwaredr'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyCallableStatement.execute(HikariProxyCallableStatement.java)
at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.LogMinerSession.getLocalDateTimeForSCN(LogMinerSession.java:720)
at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.OracleCDCSource.startGeneratorThread(OracleCDCSource.java:437)
at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.OracleCDCSource.produce(OracleCDCSource.java:320)
at com.streamsets.pipeline.api.base.configurablestage.DSource.produce(DSource.java:38)
at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:296)
at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:40)
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:244)
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:311)
at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:221)
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.processPipe(ProductionPipelineRunner.java:864)
at com.streamsets.datacollector.executio
Logfile is present on source.
Kindly advise.
Joe