Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › OGG-Oracle GoldenGate › WARNING OGG-00869 OCI Error ORA-14400
发新帖
wengtf

11

积分

0

好友

14

主题

WARNING OGG-00869 OCI Error ORA-14400

1#
发表于 2012-8-21 12:54:36 | 查看: 8357| 回复: 10
环境：
oracle: 10.2.0.2
ogg: 11.1.1.1.2
hu-ux:  11.31

ggserr.log 报错如下：
  1. 2012-08-18 15:07:29  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  No unique key is defined for table /BIC/FZPMLPC03. All viable col
  2. umns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
  3. 2012-08-18 15:07:30  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  OCI Error ORA-14400: inserted partition key does not map to any p
  4. artition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZPMLPC03P","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALU
  5. ES (:a0,:a1,:a2,:a3,:a4)>.
  6. 2012-08-18 15:07:30  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Aborted grouped transaction on 'SAPSR3./BIC/FZPMLPC03', Database
  7. error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZP
  8. MLPC03P","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>).
  9. 2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 185661450 in seqno 11.
  10. 2012-08-18 15:07:30  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL error 14400 mapping SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPM
  11. LPC03 OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZPMLPC03P
  12. ","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>.
  13. 2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 186880153 in seqno 11.
  14. 2012-08-18 15:07:30  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Error mapping from SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPMLPC03
  15. .
  16. 2012-08-18 15:07:30  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repoa.prm:  PROCESS ABENDING.
  17. 2012-08-18 15:09:29  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000012 to disk.
  18. 2012-08-18 15:09:29  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000012 to disk.
  19. 2012-08-18 15:09:29  INFO    OGG-01670  Oracle GoldenGate Collector:  Closing ./dirdat/oa000012.
  20. 2012-08-18 15:09:29  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/oa000013 (byte -1, current EOF 0).
  21. 2012-08-18 15:10:02  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params repoa.
  22. 2012-08-18 15:11:14  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start repoa.
  23. 2012-08-18 15:11:14  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.100.195.23 (START REPLICAT RE
  24. POA ).
  25. 2012-08-18 15:11:14  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPOA starting.
  26. 2012-08-18 15:11:14  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repoa.prm:  REPLICAT REPOA starting.
  27. 2012-08-18 15:11:16  INFO    OGG-00893  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL statement executed successfully.
  28. 2012-08-18 15:11:29  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, repoa.prm:  REPLICAT REPOA started.
  29. 2012-08-18 15:12:38  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000013 to disk.
  30. 2012-08-18 15:12:38  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000013 to disk.
  31. 2012-08-18 15:12:38  INFO    OGG-01670  Oracle GoldenGate Collector:  Closing ./dirdat/oa000013.
  32. 2012-08-18 15:12:38  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/oa000014 (byte -1, current EOF 0).
  33. 2012-08-18 15:12:59  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  No unique key is defined for table /BIC/FZPMLPC04. All viable col
  34. umns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
  35. 2012-08-18 15:12:59  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  OCI Error ORA-14400: inserted partition key does not map to any p
  36. artition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC04" ("KEY_ZPMLPC04P","KEY_ZPMLPC04T","KEY_ZPMLPC04U","KEY_ZPMLPC041","/BIC/ZPMCZPTJ") VALU
  37. ES (:a0,:a1,:a2,:a3,:a4)>.
  38. 2012-08-18 15:12:59  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Aborted grouped transaction on 'SAPSR3./BIC/FZPMLPC04', Database
  39. error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC04" ("KEY_ZP
  40. MLPC04P","KEY_ZPMLPC04T","KEY_ZPMLPC04U","KEY_ZPMLPC041","/BIC/ZPMCZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>).
  41. 2012-08-18 15:12:59  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 32114396 in seqno 12.
  42. 2012-08-18 15:13:00  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL error 14400 mapping SAPSR3./BIC/FZPMLPC04 to SAPSR3./BIC/FZPM
  43. LPC04 OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC04" ("KEY_ZPMLPC04P
  44. ","KEY_ZPMLPC04T","KEY_ZPMLPC04U","KEY_ZPMLPC041","/BIC/ZPMCZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>.
  45. 2012-08-18 15:13:00  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 32425135 in seqno 12.
  46. 2012-08-18 15:13:00  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Error mapping from SAPSR3./BIC/FZPMLPC04 to SAPSR3./BIC/FZPMLPC0
  47. ...
  48. ...
  49. ...
  50. .2012-08-21 07:56:54  ERROR   OGG-00199  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Table SAPSR3./BI0/0P00000012 does not exist in target database.
  51. 2012-08-21 07:56:54  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repoa.prm:  PROCESS ABENDING.
  52. 2012-08-21 07:58:46  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start repoa.
  53. 2012-08-21 07:58:46  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.100.195.23 (START REPLICAT RE
  54. POA ).
  55. 2012-08-21 07:58:46  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPOA starting.
  56. 2012-08-21 07:58:46  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repoa.prm:  REPLICAT REPOA starting.
  57. 2012-08-21 07:58:47  INFO    OGG-00893  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL statement executed successfully.
复制代码
结合上述报错，现在出现了2个问题：
1.SAPSR3./BIC/FZPMLPC04该表插入分区键的时候，没有匹配的表分区
我参考过这个帖子：http://space.itpub.net/11088128/viewspace-711613
但是查询不到 表分区的任何信息
so，分区信息都查不到 无法查对应的part_key了!!

2.SAPSR3./BI0/0P00000012
在生产库中，不管是索引，还是分区表都没查到,非常疑惑，着玩意哪来的！！？？

现在只能先mapexlude，先过滤了！求解啊求解

[ 本帖最后由 wengtf 于 2012-8-21 12:56 编辑 ]
2#
发表于 2012-8-21 13:00:34
2012-08-18 15:07:30  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Aborted grouped transaction on 'SAPSR3./BIC/FZPMLPC03', Database
error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZP
MLPC03P","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>).
2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 185661450 in seqno 11.
2012-08-18 15:07:30  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL error 14400 mapping SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPM
LPC03 OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZPMLPC03P
","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>.
2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 186880153 in seqno 11.
2012-08-18 15:07:30  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Error mapping from SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPMLPC03





"SAPSR3"."/BIC/FZPMLPC03"



列出在  source 和 target 上 这个表的DDL语句 和 分区情况

回复 只看该作者 道具 举报

3#
发表于 2012-8-21 14:12:28
刘大，这个表是sap内部维护的表，看不到ddl语句！
很遗憾的是
select partition_name, high_value from user_tab_partitions wher table_name=‘SAPSR3."/BIC/FZPMLPC03" ’;
返回 no rows
因为不知道到sapsr3密码，只能通过sys用户查看如下信息：
select * from dba_PART_KEY_COLUMNS where table=‘SAPSR3."/BIC/FZPMLPC03" ‘;
返回no rows

还有其他方法获取相关信息么，刘大！！

回复 只看该作者 道具 举报

4#
发表于 2012-8-21 14:26:55
dbms_metadata.get_ddl不可以吗？

回复 只看该作者 道具 举报

5#
发表于 2012-8-21 14:42:13
##源库：
  1. SQL> set long 90000
  2. select dbms_metadata.get_ddl('TABLE','/BIC/FZPMLPC03','SAPSR3') from dual;
  3. DBMS_METADATA.GET_DDL('TABLE','/BIC/FZPMLPC03','SAPSR3')
  4. --------------------------------------------------------------------------------

  6.   CREATE TABLE "SAPSR3"."/BIC/FZPMLPC03"
  7.    (    "KEY_ZPMLPC03P" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,

  9.         "KEY_ZPMLPC03T" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,
  10.         "KEY_ZPMLPC03U" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,
  11.         "KEY_ZPMLPC031" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,
  12.         "/BIC/ZPMGZPTJ" NUMBER(17,3) DEFAULT 0 NOT NULL ENABLE,
  13.          SUPPLEMENTAL LOG GROUP "GGS_/BIC/FZPMLPC03_514722"
  14. ("KEY_ZPMLPC03P", "KEY_ZPMLPC03T", "KEY_ZPMLPC03U",
  15. "KEY_ZPMLPC031", "/BIC/ZPMGZPTJ") ALWAYS
  16.    ) PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255
  17.   STORAGE(INITIAL 16384 NEXT 10485760 MINEXTENTS 1 MAXEXTENTS 2
  18. 147483645
  19.   PCTINCREASE 0 FREELISTS 4 BUFFER_POOL DEFAULT)
  20.   TABLESPACE "PSAPSR3"
  21.   PARTITION BY RANGE ("KEY_ZPMLPC03P")
  22. (PARTITION "/BIC/FZPMLPC030"  VALUES LESS THAN (0)
  23.   PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255
  24.   STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS
  25. 2147483645
  26.   PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  27.   TABLESPACE "PSAPSR3" NOCOMPRESS ,
  28. PARTITION "/BIC/FZPMLPC030000001284"  VALUES LESS THAN (0000001284
  29. )
  30.   PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255
  31.   STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MA
  32. XEXTENTS 2147483645
  33.   PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL
  34. DEFAULT)
  35.   TABLESPACE "PSAPSR3" NOCOMPRESS )

  37. SQL> select count(*) from sapsr3."/BIC/FZPMLPC03";
  38.   COUNT(*)
  39. ----------
  40.      90531
复制代码


##目标库：
  1. SQL> select dbms_metadata.get_ddl('TABLE','/BIC/FZPMLPC03','SAPSR3') from dual;
  2. DBMS_METADATA.GET_DDL('TABLE','/BIC/FZPMLPC03','SAPSR3')
  3. ---------------------------------------------------------------------------

  5. SQL> desc sapsr3."/BIC/FZPMLPC03"
  6. Name                                      Null?    Type
  7. ----------------------------------------- --------
  8. KEY_ZPMLPC03P                             NOT NULL NUMBER(10)
  9. KEY_ZPMLPC03T                             NOT NULL NUMBER(10)
  10. KEY_ZPMLPC03U                             NOT NULL NUMBER(10)
  11. KEY_ZPMLPC031                             NOT NULL NUMBER(10)
  12. /BIC/ZPMGZPTJ                             NOT NULL NUMBER(17,3)
  13. SQL> select count(*) from sapsr3."/BIC/FZPMLPC03";
  14.   COUNT(*)
  15. ----------
  16.      90531
复制代码

[ 本帖最后由 wengtf 于 2012-8-21 14:56 编辑 ]

回复 只看该作者 道具 举报

6#
发表于 2012-8-21 15:04:26
补充点：因为业务是ERP的高级查询，ddl复制应该可以不开（事实没开），但是现在的报错感觉又有点像！！！

回复 只看该作者 道具 举报

7#
发表于 2012-8-21 15:10:10
没有显示 目标库的DDL?

回复 只看该作者 道具 举报

8#
发表于 2012-8-21 15:15:21
原帖由 maclean 于 2012-8-21 15:10 发表
没有显示 目标库的DDL?


是的，没有

回复 只看该作者 道具 举报

9#
发表于 2012-8-21 15:17:52
翁总，以前不是出现过类似的情况了吗？开启OGG DDL复制功能。
还是初始化完成后就报错？

回复 只看该作者 道具 举报

10#
发表于 2012-8-21 15:19:22
原帖由 ShineCQY 于 2012-8-21 15:17 发表
翁总，以前不是出现过类似的情况了吗？开启OGG DDL复制功能。
还是初始化完成后就报错？

DDL复制还没开，8月18日 rman初始化之后就出现这个情况了！

回复 只看该作者 道具 举报

11#
发表于 2012-8-21 15:46:54
这贴先结贴，等开了DDL复制后，再看是否能重现该错误！！
ps：多谢，以上各位的关注！

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-18 20:19 , Processed in 0.051495 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569