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

最新推荐文章于 2025-03-28 14:58:28 发布

csdn0622

最新推荐文章于 2025-03-28 14:58:28 发布

阅读量783

点赞数 1

文章标签：数据库

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11088128/viewspace-711613/