Oracle数据库数据恢复、性能优化»论坛 › Oracle › OGG-Oracle GoldenGate › OGG目标端队列不自动清理

0 积分	1 好友	2 主题

发消息

OGG目标端队列不自动清理

1^#

发表于 2013-4-22 16:19:25 | 查看: 7610| 回复: 13

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天

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-4-22 18:47:45

换成

PurgeOldExtracts /ogg/remoteque/* , UseCheckpoints, MinKeepHours 84

试试

回复只看该作者道具举报

zhuang3088

3^#

发表于 2013-4-23 09:19:52

Maclean Liu(刘相兵发表于 2013-4-22 18:47
换成

PurgeOldExtracts /ogg/remoteque/* , UseCheckpoints, MinKeepHours 84

我试试，有结果了再回复

回复只看该作者道具举报

zhuang3088

4^#

发表于 2013-4-26 13:57:18

Maclean Liu(刘相兵发表于 2013-4-22 18:47
换成

PurgeOldExtracts /ogg/remoteque/* , UseCheckpoints, MinKeepHours 84

PurgeOldExtracts /ogg/remoteque/*, UseCheckpoints, MinKeepDays 7
以上的配置，重启了MGR还是没有生效。

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2013-4-26 14:09:35

zhuang3088 发表于 2013-4-26 13:57
PurgeOldExtracts /ogg/remoteque/*, UseCheckpoints, MinKeepDays 7
以上的配置，重启了MGR还是没有生效 ...

不理解你到底是改了MinKeepHours 还是没改

回复只看该作者道具举报

zhuang3088

6^#

发表于 2013-4-26 14:18:11

Maclean Liu(刘相兵发表于 2013-4-26 14:09
不理解你到底是改了MinKeepHours 还是没改

一定要MinKeepHours吗？

回复只看该作者道具举报

Francis鹏鹏

7^#

发表于 2013-5-8 01:52:43

生产端和灾备端trail prefix name是否相同？把两端的参数文件发出来

回复只看该作者道具举报

zhuang3088

8^#

发表于 2013-5-8 08:55:31

Francis鹏鹏发表于 2013-5-8 01:52
生产端和灾备端trail prefix name是否相同？把两端的参数文件发出来

生产端
PURGEOLDEXTRACTS /ogg/localque/*,usecheckpoints, minkeepdays 7
灾备端
PURGEOLDEXTRACTS /ogg/remoteque/*,usecheckpoints, minkeepdays 7

回复只看该作者道具举报

Francis鹏鹏

9^#

发表于 2013-5-8 11:05:56

zhuang3088 发表于 2013-5-8 08:55
生产端
PURGEOLDEXTRACTS /ogg/localque/*,usecheckpoints, minkeepdays 7
灾备端

我需要你的参数文件信息，不仅仅是MGR里面的一条参数

回复只看该作者道具举报

zhuang3088

10^#

发表于 2013-5-9 09:23:08

Francis鹏鹏发表于 2013-5-8 11:05
我需要你的参数文件信息，不仅仅是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

回复只看该作者道具举报

Francis鹏鹏

11^#

发表于 2013-5-9 21:07:09

zhuang3088 发表于 2013-5-9 09:23
源端
--view param mgr
PORT 7839

看着参数文件没什么问题，把源端和目标端/ogg/localque/和/ogg/remoteque/这两个路径下最新生成的的trail粘出来看看

回复只看该作者道具举报

zhuang3088

12^#

发表于 2013-5-10 08:51:56

Francis鹏鹏发表于 2013-5-9 21:07
看着参数文件没什么问题，把源端和目标端/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

回复只看该作者道具举报

Francis鹏鹏

13^#

发表于 2013-5-13 02:31:55

zhuang3088 发表于 2013-5-10 08:51
/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'中间加空格

回复只看该作者道具举报

zhuang3088

14^#

发表于 2013-5-13 10:50:52

Francis鹏鹏发表于 2013-5-13 02:31
我遇到过生产端和灾备端trail前缀名相同，导致无法清理trail的状况，很显然你不是这样的情况
莫非是你的 ...

谢谢你的关注，参数配置','后面有空格，我这边配置了几台唯独这台有问题，估计是人品暴发所致，我也不想纠结这个了，自己手动清理吧

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册