[求释疑]OGG的roll over操作
本帖最后由 Wizard 于 2013-5-2 14:12 编辑今天发现ogg的同步过程lag超过12个小时，查看目标端replicat一直在处理，对比目标端与源端的trail文件，发现源端470m, 目标端已经接近1G，查看源数据库，昨晚的批量更新操作已经结束，但是目标端还在应用trail文件。
查看源端log，发现记录如下：
2013-05-02 01:51:30 INFO OGG-01026 Oracle GoldenGate Capture for ODBC, EMSS03.prm: Rolling over remote file ./dirdat/z3000000.
.
.
. (略去78个）
.
2013-05-02 01:52:19 INFO OGG-01026 Oracle GoldenGate Capture for ODBC, EMSS03.prm: Rolling over remote file ./dirdat/z3000080.
然后接着roll over pump
2013-05-02 01:51:30 INFO OGG-01026 Oracle GoldenGate Capture for ODBC, PUMP03.prm: Rolling over remote file ./dirdat/z3000000.
.
.
. (略去78个）
.
2013-05-02 01:52:05 INFO OGG-01026 Oracle GoldenGate Capture for ODBC, PUMP03.prm: Rolling over remote file ./dirdat/z3000024.
所以源端只有80个trail文件，但是目标端已经超过130，还在增长。
从目前的分析看，是transaction roll back导致了lag，但是不是很清楚ogg的roll over的机制，是如何产生log的，请刘大解释一下吧？ replicat params和report发一下 REPLICAT RMSS03
ASSUMETARGETDEFS
APPLYNOOPUPDATES
TARGETDB #######, USERID #######, PASSWORD ########
DISCARDFILE ./dirrpt/RMSS03.DSC, PURGE
--HANDLECOLLISIONS
INSERTMISSINGUPDATEs
--GROUPTRANSOPS 1
--MAXTRANSOPS 1
MAP dbo.AccessMenu, TARGET dbo.AccessMenu;
MAP dbo.Attendance, TARGET dbo.Attendance;
MAP dbo.CashFloatTable, TARGET dbo.CashFloatTable;
MAP dbo.Category, TARGET dbo.Category;
MAP dbo.Chart, TARGET dbo.Chart;
MAP dbo.ConsolidatePriceTable, TARGET dbo.ConsolidatePriceTable;
MAP dbo.Customer, TARGET dbo.Customer;
MAP dbo.CustomerGroup, TARGET dbo.CustomerGroup;
MAP dbo.CustomerOrderHead, TARGET dbo.CustomerOrderHead;
MAP dbo.CustomerOrderItem, TARGET dbo.CustomerOrderItem;
MAP dbo.Department, TARGET dbo.Department;
MAP dbo.Dispatch, TARGET dbo.Dispatch;
MAP dbo.DrawerOpenRecordTable, TARGET dbo.DrawerOpenRecordTable;
MAP dbo.ElectronicProSetting, TARGET dbo.ElectronicProSetting;
MAP dbo.ExpAcct, TARGET dbo.ExpAcct;
MAP dbo.ExpDetail, TARGET dbo.ExpDetail;
MAP dbo.Expenses, TARGET dbo.Expenses;
MAP dbo.HoldHead, TARGET dbo.HoldHead;
MAP dbo.HoldItem, TARGET dbo.HoldItem;
MAP dbo.InvoiceHead, TARGET dbo.InvoiceHead, KEYCOLS (InvoiceNo);
MAP dbo.InvoiceItem, TARGET dbo.InvoiceItem, KEYCOLS (InvoiceNo, ProductCode, Qty, ID);
MAP dbo.Product, TARGET dbo.Product, KEYCOLS (ProductCode);
Repliate report 全部都是下面的记录， 依次切换至82号trail
Switching to next trail file ./dirdat/z3000003 at 2013-05-02 01:54:45 due to EOF, with current RBA 9999974
Opened trail file ./dirdat/z3000003 at 2013-05-02 01:54:45 把 Repliate report 上传为 压缩附件
页:
[1]