公司的业务系统数据库从10g升级到11g后,GoldenGate也升级到了11.2.1.0.27,升级过程一切正常。然而OGG在正常运行1星期后Extract进程异常终止了:
2014-11-20 20:01:18 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PLIS starting. 2014-11-20 20:01:20 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, elis.prm: Detect inconsistency in pdata after 6 retries, expecting tb 92577034, nf 1412, got tb 655360, nf 20, bc -1660288956, nb 1048580, on record with seqno 982, rba 16025392 for data starts at rba 11829628. 2014-11-20 20:01:21 INFO OGG-00991 Oracle GoldenGate Capture for Oracle, elis.prm: EXTRACT ELIS stopped normally. 2014-11-20 20:01:21 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, plis.prm: Socket buffer size set to 27985 (flush size 27985). 2014-11-20 20:01:21 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, plis.prm: Recovery initialization completed for target file /data/oracle/ogg/dirdat/lis/at000425, at RBA 1473. |
在Oracle Support上找到一篇文章: GoldenGate: Extract Abend with Detect Inconsistency in Pdata (Doc ID 1355067.1)说重启进程就可以,实际上无效。
在咨询了几个朋友后,都表示没有碰到过此类问题。一番努力后也没有什么结果,最后只好开SR求助Oracle。Oracle答复倒是挺快:
BugDB:20069033 , status 11 ,development working.
看来是碰到还没有修复的Bug了。。。不过好在还有解决该故障的Workaround:
ggsci> alter extract ELIS, thread 1, BEGIN 2014-11-20 00:35:21 ggsci> alter extract ELIS, thread 2, BEGIN 2014-11-20 00:35:24 ggsci> start extract ELIS
亦即通过手工分别修改Extract的两个进程的TIMESTAMP(该库是2个节点的RAC)即可解决。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13885898/viewspace-1651350/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13885898/viewspace-1651350/