OGG目标端队列不自动清理
MGR配置如下PORT 7839
DYNAMICPORTLIST 7840-7914
--AUTOSTART ER *
--AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS /ogg/remoteque/*,usecheckpoints, minkeepdays 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
队列没有自动清理。继续查看SEND MANAGER GETPURGEOLDEXTRACTS
队列停留在1个月前的06队列，而该队列之前已经手工清理掉了。
现在该如何操作，使得队列能自动清理，保留7天 换成
PurgeOldExtracts /ogg/remoteque/* , UseCheckpoints, MinKeepHours 84
试试 Maclean Liu(刘相兵 发表于 2013-4-22 18:47 static/image/common/back.gif
换成
PurgeOldExtracts /ogg/remoteque/* , UseCheckpoints, MinKeepHours 84
我试试，有结果了再回复 Maclean Liu(刘相兵 发表于 2013-4-22 18:47 static/image/common/back.gif
换成
PurgeOldExtracts /ogg/remoteque/* , UseCheckpoints, MinKeepHours 84
PurgeOldExtracts /ogg/remoteque/*, UseCheckpoints, MinKeepDays 7
以上的配置，重启了MGR还是没有生效。 zhuang3088 发表于 2013-4-26 13:57 static/image/common/back.gif
PurgeOldExtracts /ogg/remoteque/*, UseCheckpoints, MinKeepDays 7
以上的配置，重启了MGR还是没有生效 ...
不理解 你到底是改了MinKeepHours 还是没改 Maclean Liu(刘相兵 发表于 2013-4-26 14:09 static/image/common/back.gif
不理解 你到底是改了MinKeepHours 还是没改
一定要MinKeepHours吗？ 生产端和灾备端trail prefix name是否相同？把两端的参数文件发出来 Francis鹏鹏 发表于 2013-5-8 01:52 static/image/common/back.gif
生产端和灾备端trail prefix name是否相同？把两端的参数文件发出来
生产端
PURGEOLDEXTRACTS /ogg/localque/*,usecheckpoints, minkeepdays 7
灾备端
PURGEOLDEXTRACTS /ogg/remoteque/*,usecheckpoints, minkeepdays 7 zhuang3088 发表于 2013-5-8 08:55 static/image/common/back.gif
生产端
PURGEOLDEXTRACTS /ogg/localque/*,usecheckpoints, minkeepdays 7
灾备端
我需要你的参数文件信息，不仅仅是MGR里面的一条参数 Francis鹏鹏 发表于 2013-5-8 11:05 static/image/common/back.gif
我需要你的参数文件信息，不仅仅是MGR里面的一条参数
源端
--view param mgr
PORT 7839
DYNAMICPORTLIST 7840-7914
--AUTOSTART ER *
--AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS /ogg/localque/*,usecheckpoints, minkeepdays 7
PURGEOLDEXTRACTS /ogg/remoteque/*,usecheckpoints, minkeepdays 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
--view param EXT1
EXTRACT ext1
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID goldengate, PASSWORD ***, ENCRYPTKEY default
DISCARDFILE ./dirrpt/ext1.dsc , APPEND,MEGABYTES 1024
DBOPTIONS ALLOWUNUSEDCOLUMN
WARNLONGTRANS 2h,CHECKINTERVAL 3m
EXTTRAIL /ogg/localque/lt
TRANLOGOPTIONS CONVERTUCS2CLOBS
FETCHOPTIONS NOUSESNAPSHOT
GETTRUNCATES
--view param DPE1
EXTRACT dpe1
PASSTHRU
RMTHOST xx.xx.xx.xx, MGRPORT 7839, compress
RMTTRAIL /ogg/remoteque/rt
GETTRUNCATES
目标端
--view param mgr
PORT 7839
DYNAMICPORTLIST 7840-7914
--AUTOSTART ER *
--AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS /ogg/localque/*,usecheckpoints, minkeepdays 7
PURGEOLDEXTRACTS /ogg/remoteque/*,usecheckpoints, minkeepdays 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
--view param REP1
REPLICAT rep1
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID goldengate, PASSWORD ***, ENCRYPTKEY default
SQLEXEC "ALTER SESSION SET CONSTRAINTS=DEFERRED"
REPORT AT 01:59
REPORTCOUNT EVERY 720 MINUTES, RATE
REPERROR DEFAULT, ABEND
assumetargetdefs
DISCARDFILE ./dirrpt/rep1.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 02:30
GETTRUNCATES
ALLOWNOOPUPDATES
zhuang3088 发表于 2013-5-9 09:23 static/image/common/back.gif
源端
--view param mgr
PORT 7839
看着参数文件没什么问题，把源端和目标端/ogg/localque/和/ogg/remoteque/这两个路径下最新生成的的trail粘出来看看 Francis鹏鹏 发表于 2013-5-9 21:07 static/image/common/back.gif
看着参数文件没什么问题，把源端和目标端/ogg/localque/和/ogg/remoteque/这两个路径下最新生成的的trail ...
/ogg/localque >ls -lart
total 34428952
drwxr-xr-x 7 ogg dba 256 Nov 11 14:50 ..
-rw-rw-rw- 1 ogg dba 1023999539 May 3 13:10 lt000132
-rw-rw-rw- 1 ogg dba 1023998889 May 3 20:29 lt000133
-rw-rw-rw- 1 ogg dba 1023999034 May 4 14:08 lt000134
-rw-rw-rw- 1 ogg dba 1023998079 May 4 20:12 lt000135
-rw-rw-rw- 1 ogg dba 1023997954 May 5 13:30 lt000136
-rw-rw-rw- 1 ogg dba 1023997747 May 5 19:10 lt000137
-rw-rw-rw- 1 ogg dba 1023999658 May 6 13:55 lt000138
-rw-rw-rw- 1 ogg dba 1023999820 May 7 00:37 lt000139
-rw-rw-rw- 1 ogg dba 1023998315 May 7 16:52 lt000140
-rw-rw-rw- 1 ogg dba 1023998565 May 7 22:22 lt000141
-rw-rw-rw- 1 ogg dba 1023999818 May 8 02:08 lt000142
-rw-rw-rw- 1 ogg dba 1023998548 May 8 08:00 lt000143
-rw-rw-rw- 1 ogg dba 1023999899 May 8 08:05 lt000144
-rw-rw-rw- 1 ogg dba 1023998007 May 8 15:18 lt000145
-rw-rw-rw- 1 ogg dba 1023998435 May 8 23:54 lt000146
-rw-rw-rw- 1 ogg dba 1023999338 May 9 15:17 lt000147
-rw-rw-rw- 1 ogg dba 1023999806 May 9 21:50 lt000148
drwxr-xr-x 2 ogg dba 4096 May 9 21:50 .
-rw-rw-rw- 1 ogg dba 219564338 May 10 08:50 lt000149
/ogg/remoteque >ls -lart
total 95653440
drwxr-xr-x 7 ogg oinstall 4096 Nov 16 12:10 ..
-rw-rw-rw- 1 ogg dba 1023999364 Apr 19 00:11 rt000100
-rw-rw-rw- 1 ogg dba 1023998454 Apr 19 00:15 rt000101
-rw-rw-rw- 1 ogg dba 1023999915 Apr 19 02:41 rt000102
-rw-rw-rw- 1 ogg dba 1023998115 Apr 19 14:03 rt000103
-rw-rw-rw- 1 ogg dba 1023998494 Apr 19 20:36 rt000104
-rw-rw-rw- 1 ogg dba 1023998695 Apr 20 13:40 rt000105
-rw-rw-rw- 1 ogg dba 1023999877 Apr 20 19:19 rt000106
-rw-rw-rw- 1 ogg dba 1023999780 Apr 21 12:26 rt000107
-rw-rw-rw- 1 ogg dba 1023999887 Apr 21 17:43 rt000108
-rw-rw-rw- 1 ogg dba 1023999429 Apr 22 11:22 rt000109
-rw-rw-rw- 1 ogg dba 1023998071 Apr 22 19:46 rt000110
-rw-rw-rw- 1 ogg dba 1023999610 Apr 23 14:46 rt000111
-rw-rw-rw- 1 ogg dba 1023998437 Apr 24 08:34 rt000112
-rw-rw-rw- 1 ogg dba 1023999665 Apr 24 17:13 rt000113
-rw-rw-rw- 1 ogg dba 621292200 Apr 25 00:25 rt000114
-rw-rw-rw- 1 ogg dba 3888497 Apr 25 01:21 rt000115
-rw-rw-rw- 1 ogg dba 1023999050 Apr 25 16:31 rt000116
-rw-rw-rw- 1 ogg dba 1023999816 Apr 26 10:28 rt000117
-rw-rw-rw- 1 ogg dba 1023999299 Apr 26 18:08 rt000118
-rw-rw-rw- 1 ogg dba 1023998597 Apr 27 11:30 rt000119
-rw-rw-rw- 1 ogg dba 1023999533 Apr 27 18:43 rt000120
-rw-rw-rw- 1 ogg dba 1023999773 Apr 28 12:00 rt000121
-rw-rw-rw- 1 ogg dba 1023997714 Apr 28 18:33 rt000122
-rw-rw-rw- 1 ogg dba 1023999912 Apr 29 11:17 rt000123
-rw-rw-rw- 1 ogg dba 1023999459 Apr 29 16:58 rt000124
-rw-rw-rw- 1 ogg dba 1023998517 Apr 30 09:25 rt000125
-rw-rw-rw- 1 ogg dba 1023997750 Apr 30 15:20 rt000126
-rw-rw-rw- 1 ogg dba 1023999468 Apr 30 20:39 rt000127
-rw-rw-rw- 1 ogg dba 1023998215 May 1 13:07 rt000128
-rw-rw-rw- 1 ogg dba 1023999362 May 1 17:50 rt000129
-rw-rw-rw- 1 ogg dba 1023998552 May 2 11:31 rt000130
-rw-rw-rw- 1 ogg dba 1023998484 May 2 18:48 rt000131
-rw-rw-rw- 1 ogg dba 1023998231 May 3 13:10 rt000132
-rw-rw-rw- 1 ogg dba 1023999353 May 3 20:29 rt000133
-rw-rw-rw- 1 ogg dba 1023999980 May 4 14:08 rt000134
-rw-rw-rw- 1 ogg dba 1023999746 May 4 20:12 rt000135
-rw-rw-rw- 1 ogg dba 1023998626 May 5 13:30 rt000136
-rw-rw-rw- 1 ogg dba 1023997784 May 5 19:10 rt000137
-rw-rw-rw- 1 ogg dba 1023999695 May 6 13:55 rt000138
-rw-rw-rw- 1 ogg dba 1023999857 May 7 00:37 rt000139
-rw-rw-rw- 1 ogg dba 1023998352 May 7 16:52 rt000140
-rw-rw-rw- 1 ogg dba 1023998602 May 7 22:22 rt000141
-rw-rw-rw- 1 ogg dba 1023999855 May 8 02:08 rt000142
-rw-rw-rw- 1 ogg dba 1023998585 May 8 08:01 rt000143
-rw-rw-rw- 1 ogg dba 1023999936 May 8 08:05 rt000144
-rw-rw-rw- 1 ogg dba 1023998044 May 8 15:18 rt000145
-rw-rw-rw- 1 ogg dba 1023998472 May 8 23:54 rt000146
-rw-rw-rw- 1 ogg dba 1023999375 May 9 15:17 rt000147
-rw-rw-rw- 1 ogg dba 1023999843 May 9 21:50 rt000148
drwxr-xr-x 2 ogg dba 4096 May 9 21:50 .
-rw-rw-rw- 1 ogg dba 221159219 May 10 08:51 rt000149 zhuang3088 发表于 2013-5-10 08:51 static/image/common/back.gif
/ogg/localque >ls -lart
total 34428952
drwxr-xr-x 7 ogg dba 256 Nov 11 14:50 . ...
我遇到过生产端和灾备端trail前缀名相同，导致无法清理trail的状况，很显然你不是这样的情况
莫非是你的参数','后面没有空格吗？
写成这样PURGEOLDEXTRACTS /ogg/localque/*, usecheckpoints, minkeepdays 7
','和'usecheckpoints'中间加空格 Francis鹏鹏 发表于 2013-5-13 02:31 static/image/common/back.gif
我遇到过生产端和灾备端trail前缀名相同，导致无法清理trail的状况，很显然你不是这样的情况
莫非是你的 ...
谢谢你的关注，参数配置','后面有空格，我这边配置了几台唯独这台有问题，估计是人品暴发所致，我也不想纠结这个了，自己手动清理吧
页:
[1]