OCI Error ORA-01403: no data found,SQL <DELETE FROM "DB_FPZX"."LIULIU" WHERE "ID" = :b0> Aborting transaction on /u01/goldengate/dirdat/fp beginning at seqno 6 rba 1259 error at seqno 6 rba 1259 Problem replicating DB_FPZX.LIULIU to DB_FPZX.LIULIU Record not found Mapping proble...
To turn on supplemental logging at the database level, GoldenGate requires this command to be executed: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; This change to add supplemental logging will not take effect until the current redo log is switched, so the following command must also be executed:...
Discarded record from action ABEND on error 1403 OCI Error ORA-01403: no data found,SQL <DELETE FROM "DB_FPZX"."LIULIU" WHERE "ID" = :b0> Aborting transaction on /u01/goldengate/dirdat/fp beginning at seqno 6 rba 1259 error at seqno 6 rba 1259 Problem replicating DB_FPZX.LIULIU t...
OGG出现表数据不同步,入库端接收update和delete语句时出现ORA-01403 错误NO data found 解决方案 1.1 解决思路 先将不能同步的表忽略,tableexclude yx_data.df_myfx_dw_flhzb; 启动replicat进程,启动成功,将数据同步完成,然后停掉replicat。 把不能应用的表进行重新同步使用expdp/impdp。 在参数文件中,将参数 --...
OCI Error ORA-01403: no data found, SQL RATE" = :a4,“TEST_ID” = :a5 WHERE “TEST_ID” = :b0> Aborting transaction on ./dirdat/yt beginning at seqno 12 rba 170249512 error at seqno 12 rba 170249512 Problem replicating OGG_TEST.FM_TAX_RATE_TEST to OGG_TEST.FM_TAX_RATE_TEST ...
OGG ORA-1403 NO DATA FOUND 近期开始做OGG的项目,测试过程中遇到一个问题。使用CTAS创建一张表,表中有数据,然后使用delete from xxx;删除表之后,replicat进程异常。查看ogg日志,查看官网找到原因。 官方文档号 How to Capture the DML(s) Executed by a DDL Trigger (OGG) (文档 ID 1509900.1)...
OCI Error ORA-01403: no data found, SQL <UPDATE "OGG_TEST"."FM_TAX_RATE_TEST" SET "COUNTRY" = :a1,"STATE" = :a2,"TAX_TYPE" = :a3,"TAX_ RATE" = :a4,"TEST_ID" = :a5 WHERE "TEST_ID" = :b0> Aborting transaction on ./dirdat/yt beginning at seqno 12 rba 170249512 ...
OCI Error ORA-01403: no data found, SQL <UPDATE "OGG_TEST"."FM_TAX_RATE_TEST" SET "COUNTRY" = :a1,"STATE" = :a2,"TAX_TYPE" = :a3,"TAX_ RATE" = :a4,"TEST_ID" = :a5 WHERE "TEST_ID" = :b0> Aborting transaction on ./dirdat/yt beginning at seqno 12 rba 170249512 ...
ORA-01403: no data found, SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "YTMAT"."XIAOXU" x SET x."RK" = :a6, x.QTY" = :a7,x."MEMO = :a8,x."EXT" = :a9,x."2" = :a10, x."ORDERTIME" = : WHERE x."RK" :b0 AND x."QTY" = :b1 ANDx."MEMO" = :b2...
OGG复制进程Not found处理 OGG运维,经常遇到复制进程ORA-01403: no data found, SQL error 进程报错~ 如下进行学习测试 1.数据重新初始化; 2.使用 HANDLECOLLISIONS; 3.手工查询差异数据,手工补数据。 1.测试数据准备 SQL>select*fromdd; ID CC_NAME WITTIME--- --- ---2203-JUN-2002.34.37.000000PM SQL>...