故障： 昨天客戶處的ogg rep進程報ora-01403,然后update語句執行失敗。 環境是：11.2.0.3.8 rac，asm方式，ogg是11.2.1.0.27 分析： 1.logdump分析目的端的trail file， 發現pkgid='4605'的insert記錄不在目的端的trail file中 2.logdump分析源頭上的trail file， 發現pkgid='4605'的insert記錄不在源頭的trail file中 3.至此，問題得到定性：ogg源頭的抽取進程漏抽數據。 4.檢查ogg源頭的抽取進程的rpt文件， ~~~ 2015-11-23 3:40:16 WARNING OGG-01027 Long Running Transaction: XID 8.2.3069, Items 0, Extract EXTXXX, Redo Thread 2, SCN 17.3644768588 (76659212620), Redo Seq #3153, Redo RBA 434248208. 2015-11-23 3:45:16 WARNING OGG-01027 Long Running Transaction: XID 8.2.3069, Items 0, Extract EXTXXX, Redo Thread 2, SCN 17.3644768588 (76659212620), Redo Seq #3153, Redo RBA 434248208. 2015-11-23 3:50:16 WARNING OGG-01027 Long Running Transaction: XID 8.2.3069, Items 0, Extract EXTXXX, Redo Thread 2, SCN 17.3644768588 (76659212620), Redo Seq #3153, Redo RBA 434248208. 2015-11-23 3:55:16 WARNING OGG-01027 Long Running Transaction: XID 8.2.3069, Items 0, Extract EXTXXX, Redo Thread 2, SCN 17.3644768588 (76659212620), Redo Seq #3153, Redo RBA 434248208. 2015-11-23 4:00:16 WARNING OGG-01027 Long Running Transaction: XID 8.2.3069, Items 0, Extract EXTXXX, Redo Thread 2, SCN 17.3644768588 (76659212620), Redo Seq #3153, Redo RBA 434248208. 2015-11-23 4:02:53 WARNING OGG-00723 Record with class# 78, slt# 8, at seqno 3546, rba 334954000 SCN 18.56689670 (77366100998) has secondary transaction ID that is duplicate of existing open uncommitted transaction. 2015-11-23 4:02:53 WARNING OGG-00715 [Thread #2] Purging transaction (transaction id: 31.8.122377, start time: 2015-11-24 13:57:04, start seqno: 3546, start RBA: 318146576). 2015-11-23 4:02:53 WARNING OGG-00712 Updating I/O checkpoint after purging orphaned transactions on thread 2 with current position (Seq#: 3546, RBA: 334957552). ~~~ 重點是最后3行的信息（前5行的信息都是長事務的報警），以最后3行的信息去mos搜索，發現如下的mos文章: ~~~ GG Extract Report Shows "Purging Transaction", WARNING OGG-00723, OGG-00715, Updating I/O Checkpoint after Purging Orphaned Transactions, Has Secondary Transaction ID That Is Duplicate of Existing Open Uncommitted Transaction (文檔 ID 1458472.1) Classic Extract reports false redo corruption errors when using the DBLOGREADER interface (文檔 ID 2014521.1) Replicat abends due to a record missed by an extract (文檔 ID 1990385.1) GoldenGate Replication On RAC (文檔 ID 2079091.1) ~~~ 如上文章說的是有個ogg的隱含參數TRANLOGOPTIONS _DISABLESTREAMLINEDDBLOGREADER 該隱含參數的作用如下： ~~~ This parameter will force DBLOGREADER api check the NAB flag of the redo log before switching, thus eliminate the chance of switching to the new log file prematurely. This parameter has become default from V12.1.2.1.0 and up. Note: The parameter _DISABLESTREAMLINEDDBLOGREADER is available only from v11.2.1.0.26 onwards ~~~ 于是，就在ogg源頭的抽取進程中添加了這個隱含參數（加在了TRANLOGOPTIONS DBLOGREADER下面一行），重啟了ogg源頭的抽取進程。 繼續觀察運行情況。