ITPub博客

首页 > 数据库 > Oracle > OGG-01396 OGG-01004 OGG-00869报错

OGG-01396 OGG-01004 OGG-00869报错

原创 Oracle 作者:羽化残虹 时间:2014-11-10 17:39:00 0 删除 编辑
实施OGG 的时候发现了一个问题
在复制端的复制进程发现已经abend,查看报错


2014-11-05 09:14:29  WARNING OGG-01396  A complete after image is not available in JHYB.KC08 at rba 95827127 in file ./dirdat
/yb000010, while inserting a row into JHYB.KC08 due to missing target row for a key update operation. NOCOMPRESSUPDATES or FE
TCHOPTIONS FETCHPKUPDATECOLS may be specified in the EXTRACT parameter file to include a complete image for key update operat
ions.


2014-11-05 09:14:29  WARNING OGG-00869  OCI Error ORA-01400: cannot insert NULL into ("JHYB"."KC08"."AAC001") (status = 1400)
. INSERT INTO "JHYB"."KC08" ("EKE028") VALUES (:a0).


2014-11-05 09:14:29  WARNING OGG-01004  Aborted grouped transaction on 'JHYB.KC08', Database error 1400 (OCI Error ORA-01400:
 cannot insert NULL into ("JHYB"."KC08"."AAC001") (status = 1400). INSERT INTO "JHYB"."KC08" ("EKE028") VALUES (:a0)).


2014-11-05 09:14:29  WARNING OGG-01003  Repositioning to rba 95823213 in seqno 10.


2014-11-05 09:14:29  WARNING OGG-01154  SQL error 1400 mapping JHYB.KC08 to JHYB.KC08 OCI Error ORA-01400: cannot insert NULL
 into ("JHYB"."KC08"."AAC001") (status = 1400). INSERT INTO "JHYB"."KC08" ("EKE028") VALUES (:a0).


2014-11-05 09:14:29  WARNING OGG-01003  Repositioning to rba 95823213 in seqno 10.


Source Context :
  SourceModule            : [er.errors]
  SourceID                : [/scratch/aime1/adestore/views/aime1_staxk20/oggcore/OpenSys/src/app/er/errors.cpp]
  SourceFunction          : [take_rep_err_action(short, int32_t, const char *, extr_ptr_def *, std_rec_hdr_def *, char *, fil
e_def *, bool)]
  SourceLine              : [623]


2014-11-05 09:14:29  ERROR   OGG-01296  Error mapping from JHYB.KC08 to JHYB.KC08.


***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************


Reading ./dirdat/yb000010, current RBA 95827127, 7 records

此问题网上查询了一下 

alter extractext1,extseqno 0,extrba 0
alter replicat rpjhyb,extseqno 10,extrba 95823213


alter replicat rpjhyb,extseqno 10,extrba 95823214


alter replicat rpjhyb,extseqno 10,extrba 95823215
alter replicat rpjhyb,extseqno 11,extrba 0



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

下一篇: OGG TROUBLESHOOTING
请登录后发表评论 登录
全部评论

注册时间:2013-08-24

  • 博文量
    69
  • 访问量
    290441