GoldenGate extract process abended with error OGG-01028的處理
公司的業務系統資料庫從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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- goldengate extract abended unable to queue I/O, I/O beyond file sizeGo
- oracle goldengate ddl 操作導致複製程式abended處理案例OracleGo
- oracle goldengate 目標端表空間滿導致程式abended處理過程OracleGo
- goldengate的extract程式調優Go
- OGG複製程式掛起abended處理
- goldengate的Collector processGo
- OGG-01028錯誤處理
- error的處理方式Error
- ERROR OGG-01028Error
- 關於Oracle GoldenGate中Extract的checkpoint的理解OracleGo
- GoldenGate COLMAP字串處理Go字串
- OGG-01028問題處理記錄
- build Error -- extract-text-webpack-pluginUIErrorWebPlugin
- GoldenGate常見異常處理Go
- goldengate故障處理一例Go
- ORA-00704: bootstrap process failure 的處理bootAI
- OGG-01028 Recovery record is missing from log 的BUG處理
- OGG-01028 Opening file errorError
- GoldenGate常見問題及處理Go
- goldengate故障處理一例(續)Go
- ksvcreate: Process(m000) creation failed 處理AI
- GoldenGate Extract程式hang問題解決一例Go
- [譯] Part 30: Golang 中的Error處理GolangError
- ORA-00600 Error的通用處理Error
- MySql之json_extract函式處理json欄位MySqlJSON函式
- OGG-01028 Recovery record is missing ERRORError
- 【goldengate】官方文件筆記二 Oracle GoldenGate 處理介面(GGSCI)Go筆記Oracle
- 15-錯誤處理(Error)Error
- Rails全域性處理Error薦AIError
- ORACLE GoldenGate 使用技巧-容錯處理等OracleGo
- Extract or Replicat Fail to Start (Don't Start) With No Error MessagesAIError
- 【故障處理】Bug : ASM FAILS WITH CHECKRESOURCE ERROR ERROR CODE = 139ASMAIError
- OGG-01028 Recovery record is missing ERROR[續]Error
- 【GoldenGate】OGG-01163的處理方法Go
- Spring Boot Web Error Page處理Spring BootWebError
- goldengate ddl_setup執行失敗處理Go
- kkjcre1p: unable to spawn jobq slave process故障處理
- 處理ksvcreate: Process(m000) creation failed 小記AI