ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【故障-goldengate】WARNING OGG-00869 OCI Error ORA-14400

【故障-goldengate】WARNING OGG-00869 OCI Error ORA-14400

原创 Linux操作系统 作者:浪漫双鱼 时间:2011-11-18 22:57:02 0 删除 编辑

  golden gate报错日志如下:

2011-11-18 17:06:38  WARNING OGG-01396  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  A complete after image is not available in NEWINFO.OTHERRIGHT_HIS at rba 3708046 in file ./dirdat/r1000378, while inserting a row into NEWINFO.OTHERRIGHT_HIS due to missing target row for a key update operation. NOCOMPRESSUPDATES or FETCHOPTIONS FETCHPKUPDATECOLS may be specified in the EXTRACT parameter file to include a complete image for key update operations.

2011-11-18 17:06:38  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL .

2011-11-18 17:06:38  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  Aborted grouped transaction on 'NEWINFO.OTHERRIGHT_HIS', Database error 14400 (ORA-14400: inserted partition key does not map to any partition).

2011-11-18 17:06:38  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  Repositioning to rba 3708046 in seqno 378.

2011-11-18 17:06:38  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  SQL error 14400 mapping NEWINFO.OTHERRIGHT_HIS to NEWINFO.OTHERRIGHT_HIS OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL .

2011-11-18 17:06:38  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  Repositioning to rba 3708046 in seqno 378.

2011-11-18 17:06:38  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rora_001.prm:  Error mapping from NEWINFO.OTHERRIGHT_HIS to NEWINFO.OTHERRIGHT_HIS.

通过错误ORA-14400: inserted partition key does not map to any partition分析可以得知错误原因是要插入的值没有匹配的表分区,所以无法插入数据,就是插入数据值超出了分区限定的最大值。

我们可以通过查看分区情况然后添加表分区

SQL> select partition_name, High_value from user_tab_partitions where table_name='OTHERRIGHT_HIS';

查看分区基于那个字段

select * from USER_PART_KEY_COLUMNS where table='OTHERRIGHT_HIS';

添加表分区

alter table NEWINFO.OTHERRIGHT_HIS add partition Pxx values less than (10000) tablespace DFJINFO;

 

   通过如上处理,ogg正常了。

其实处理goldengate的故障很多时候要分析oracle数据库的问题,我们从ORA-这类报错里能看出大部分的问题了。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11088128/viewspace-711613/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    87
  • 访问量
    242890