Goldengate的复制进程出错OGG-01296

复制进程错误日志：

2011-04-29 15:32:40  WARNING OGG-01004  Aborted grouped transaction on 'CHQING.OMS_CLIENT_TAB_RELATION', Database error 100 (retrieving bind info for query).

 

2011-04-29 15:32:40  WARNING OGG-01003  Repositioning to rba 26715058 in seqno 1.

 

2011-04-29 15:32:40  WARNING OGG-01003  Repositioning to rba 26715058 in seqno 1.

 

Source Context :

  SourceModule            : [er.main]

  SourceID                : [/mnt/ecloud/workspace/Build_OpenSys_r11.1.1.0.15_001_[41784]/perforce/src/app/er/rep.c]

  SourceFunction          : [take_rep_err_action]

  SourceLine              : [15809]

 

2011-04-29 15:32:40  ERROR   OGG-01296  Error mapping from CHQING.OMS_CLIENT_TAB_RELATION to CHQING.OMS_CLIENT_TAB_RELATION.

 

***********************************************************************

*                   ** Run Time Statistics **                         *

***********************************************************************

 

Last record for the last committed transaction is the following:

___________________________________________________________________

Trail name :  /oragg/oggst/dirdat/sb000001

Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)

UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)

RecLength  :    99 (x0063)    IO Time    : 2011-04-29 10:22:17.352327 

IOType     :    15  (x0f)     OrigNode   :   255  (xff)

TransInd   :     .  (x03)     FormatType :     R  (x52)

SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)

AuditRBA   :       2336       AuditPos   : 6608912

Continued  :     N  (x00)     RecCount   :     1  (x01)

 

2011-04-29 10:22:17.352327 FieldComp          Len    99 RBA 26715058

Name: CHQING.OMS_CLIENT_TAB_RELATION

___________________________________________________________________

 

Reading /oragg/oggst/dirdat/sb000001, current RBA 26715058, 0 records

 

Report at 2011-04-29 15:32:40 (activity since 2011-04-29 15:32:40)

 

From Table CHQING.OMS_CLIENT_TAB_RELATION to CHQING.OMS_CLIENT_TAB_RELATION:

       #                   inserts:         0

       #                   updates:         0

       #                   deletes:         0

       #                  discards:         2

 

忽略错误不能启动：

start replicat repsb skiptransaction

 

使用PLSQL连接源数据库，同时连接备库，比较该表的数据，然后把比较出来的结果在备库执行。

 

然后再启动复制进程

start replicat repsb

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

转载于:http://blog.itpub.net/12778571/viewspace-694122/