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

浪漫雙魚發表於2011-11-18
GoError

  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章