Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

86

积分

0

好友

4

主题
1#
发表于 2013-5-2 14:09:32 | 查看: 6209| 回复: 4
本帖最后由 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的,请刘大解释一下吧?
2#
发表于 2013-5-2 14:23:01
replicat params和report发一下

回复 只看该作者 道具 举报

3#
发表于 2013-5-2 14:28:04
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);

回复 只看该作者 道具 举报

4#
发表于 2013-5-2 14:32:12
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

回复 只看该作者 道具 举报

5#
发表于 2013-5-2 15:03:05
把 Repliate report  上传为 压缩附件

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-18 18:27 , Processed in 0.060789 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569