设为首页 加入收藏

TOP

SQLerror1403:ogg同步(一)
2015-11-21 01:49:58 来源: 作者: 【 】 浏览:0
Tags:SQLerror1403 ogg 同步

同步目标端失败报错:

2015-05-21 09:33:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repraca.prm: PROCESS ABENDING.
2015-05-21 09:39:33 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPRACA starting.
2015-05-21 09:39:33 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPRACA restarted automatically.
2015-05-21 09:39:33 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repraca.prm: REPLICAT REPRACA starting.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, repraca.prm: SQL statement executed successfully.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, repraca.prm: SQL statement executed successfully.
2015-05-21 09:39:33 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repraca.prm: REPLICAT REPRACA started.
2015-05-21 09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repraca.prm: No unique key is defined for table MET_NUI_ALLERGEN. All viable
columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2015-05-21 09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repraca.prm: Aborting BATCHSQL transaction. Detected inconsistent result: ex
ecuted 1 operations in batch, resulting in 0 affected rows.
2015-05-21 09:39:33 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, repraca.prm: BATCHSQL suspended, continuing in normal mode.
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm: Repositioning to rba 1933837 in seqno 4.
2015-05-21 09:39:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, repraca.prm: Aborted grouped transaction on 'HIS.MET_NUI_ALLERGEN', Database
error 1403 ().
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm: Repositioning to rba 1933837 in seqno 4.
2015-05-21 09:39:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, repraca.prm: SQL error 1403 mapping HIS.MET_NUI_ALLERGEN to HIS.MET_NUI_ALLE
RGEN.
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm: Repositioning to rba 1933837 in seqno 4.
2015-05-21 09:39:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, repraca.prm: Error mapping from HIS.MET_NUI_ALLERGEN to HIS.MET_NUI_ALLERGEN
.
2015-05-21 09:39:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repraca.prm: PROCESS ABENDING.
2015-05-21 09:42:33 WARNING OGG-00947 Oracle GoldenGate Manager for Oracle, mgr.prm: Lag for REPLICAT REPRACA is 00:11:17 (checkpoint updated 00:02:59 ag
o).

?

logdump 找到数据更改信息

Logdump 519 >sfh
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 396 (x018c) IO Time : 2015/05/21 09:28:15.994.354
IOType : 115 (x73) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 21 AuditPos : 214992528
Continued : N (x00) RecCount : 1 (x01)


2015/05/21 09:28:15.994.354 GGSPK Update Len 396 RBA 1933837 --更新语句问题 手动更新,跳过该语句...
Name: HIS.MET_NUI_ALLERGEN
After Image: Partition 4 G s
00c5 0000 000b 0000 0007 3230 3635 3630 3700 0100 | ..........2065607...
0500 0000 0131 0002 0008 0000 0004 4139 3939 0003 | .....1........A999..
000a 0000 0006 b0d7 bcd3 bada 0004 0005 0000 0001 | ....................
3300 0500 0500 0000 0131 0006 0004 ffff 0000 0007 | 3........1

首页 上一页 1 2 下一页 尾页 1/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇安装sqlserver2008的教训 下一篇游戏测试中的sql语句

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: