问题描述
ogg已经配置自动清理, 但是无法清理tail文件
GGSCI (odb-wx045-s172) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT RUNNING EXTRACT RUNNING D_DC_172 00:00:00 00:00:01 EXTRACT RUNNING D_IB_172 00:00:00 00:00:08 EXTRACT RUNNING D_RC_173 00:00:02 00:00:01 EXTRACT RUNNING E_DC_172 00:00:00 00:00:09 EXTRACT RUNNING E_IB_172 00:00:00 00:00:09 EXTRACT RUNNING E_RC_173 00:00:00 00:00:05 GGSCI (odb-wx045-s172) 2> view params mgr --mgr PORT 7839 DYNAMICPORTLIST 7840-7914 purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 3 AUTORESTART REPLICAT *, WAITMINUTES 2, RETRIES 5 LAGREPORTHOURS 1 LAGINFOMINUTES 3 LAGCRITICALMINUTES 5 GGSCI (odb-wx045-s172) 3> send mgr,getpurgeoldextracts Sending GETPURGEOLDEXTRACTS request to MANAGER ... PurgeOldExtracts Rules Fileset MinHours MaxHours MinFiles MaxFiles UseCP /data/goldengate/dirdat/* 72 0 1 0 Y OK Extract Trails Filename Oldest_Chkpt_Seqno IsTable IsVamTwoPhaseCommit /data/goldengate/dirdat/ca 2825 /data/goldengate/dirdat/cb 9 /data/goldengate/dirdat/cc 5353
ggserr.log
2019-03-12 15:32:10 WARNING OGG-00959 Oracle GoldenGate Manager for Oracle, mgr.prm: purgeoldextracts ./dirdat/*,usecheckpoints, minkeephours 72,MINKEEPFILES 1 (MINKEEPFILES option not used.).
专家解答
pump检查和extract进程使用了相同的队列文件名,如D_RC_173和E_RC_173都是./dirdat/cc,分别的Seqno为5429和18154,OGG删除时候会取小值5429,而目录下没有小于5429的队列文件,所以就无法删除。
GGSCI (odb-wx045-s172) 3> info rmttrail * Extract Trail: ./dirdat/ca Extract: D_DC_172 Seqno: 4442 RBA: 58511977 File Size: 100M Extract Trail: ./dirdat/cb Extract: D_IB_172 Seqno: 21 RBA: 186953 File Size: 100M Extract Trail: ./dirdat/cc Extract: D_RC_173 Seqno: 5429 RBA: 32851741 File Size: 100M Extract Trail: ./dirdat/ca Extract: E_DC_172 Seqno: 2837 RBA: 66192430 File Size: 100M Extract Trail: ./dirdat/cb Extract: E_IB_172 Seqno: 9 RBA: 5494858 File Size: 100M Extract Trail: ./dirdat/cc Extract: E_RC_173 Seqno: 18154 RBA: 58664071 File Size: 100M
如果要使用自动清理就需要将抽取进程和投递进程的队列文件名改为不一样,或者将两边的队列文件序列号调整为相近。
最后修改时间:2019-04-12 14:38:10
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。