暂无图片
返回问答列表
分享
莫得感情的萝卜头
2019-03-13
ogg自动清理无效
oracle

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.).


收藏
分享
7条回答
默认
最新
章芋文

请修改purgeoldextracts如下再试试：

purgeoldextracts /data/goldengate/dirdat/* , usecheckpoints,  minkeepdays 3

加了绝对路径，*号后多了一个空格

暂无图片 评论
暂无图片 有用 0
莫得感情的萝卜头

还是如此

GGSCI (odb-wx045-s172) 9> view params mgr

--mgr

PORT 7839

DYNAMICPORTLIST 7840-7914

purgeoldextracts /data/goldengate/dirdat/* ,usecheckpoints,  minkeepdays 3

AUTORESTART REPLICAT *, WAITMINUTES 2, RETRIES 5

LAGREPORTHOURS 1

LAGINFOMINUTES 3

LAGCRITICALMINUTES 5



2019-03-13 13:42:55  WARNING OGG-00959  Oracle GoldenGate Manager for Oracle, mgr.prm:  purgeoldextracts /data/goldengate/dirdat/* ,usecheckpoints,  minkeepdays 3 (MINKEEPFILES option not used.).

暂无图片 评论
暂无图片 有用 0
章芋文

usecheckpoints前面也有空格。

另外检查下有没有rmttrail和exttrail同名的情况。

暂无图片 评论
暂无图片 有用 0
章芋文

尝试清理其中一个试试：

purgeoldextracts /data/goldengate/dirdat/cc*, usecheckpoints,  minkeepdays 3

另外看下：

info rmttrail *
send manager GETPURGEOLDEXTRACTS
send E* status

再查看下目录下的文件：

ls -l /data/goldengate/dirdat/
暂无图片 评论
暂无图片 有用 0
莫得感情的萝卜头

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:07    

EXTRACT     RUNNING     D_IB_172    00:00:00      00:00:06    

EXTRACT     RUNNING     D_RC_173    00:00:00      00:00:07    

EXTRACT     RUNNING     E_DC_172    00:00:00      00:00:08    

EXTRACT     RUNNING     E_IB_172    00:00:00      00:00:00    

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 /data/goldengate/dirdat/cc* , usecheckpoints,  minkeepdays 3

AUTORESTART REPLICAT *, WAITMINUTES 2, RETRIES 5

LAGREPORTHOURS 1

LAGINFOMINUTES 3

LAGCRITICALMINUTES 5

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

GGSCI (odb-wx045-s172) 4> send manager GETPURGEOLDEXTRACTS

Sending GETPURGEOLDEXTRACTS request to MANAGER ...

PurgeOldExtracts Rules

Fileset                              MinHours MaxHours MinFiles MaxFiles UseCP

/data/goldengate/dirdat/cc*                72        0        1        0   Y

OK

Extract Trails

Filename                        Oldest_Chkpt_Seqno  IsTable  IsVamTwoPhaseCommit

/data/goldengate/dirdat/ca     2837

/data/goldengate/dirdat/cb        9

/data/goldengate/dirdat/cc     5429

GGSCI (odb-wx045-s172) 5> send E* status

Sending STATUS request to EXTRACT E_DC_172 ...

EXTRACT E_DC_172 (PID 19364)

  Current status: Recovery complete: At EOF

  Current read position:

  Redo thread #: 1

  Sequence #: 13097

  RBA: 1706361856

  Timestamp: 2019-03-14 14:05:15.000000

  SCN: 47.585682736

  Current write position:

  Sequence #: 2837

  RBA: 66233834

  Timestamp: 2019-03-14 14:05:13.078798

  Extract Trail: ./dirdat/ca

Sending STATUS request to EXTRACT E_IB_172 ...

EXTRACT E_IB_172 (PID 19365)

  Current status: Recovery complete: At EOF

  Current read position:

  Redo thread #: 1

  Sequence #: 13097

  RBA: 1707865600

  Timestamp: 2019-03-14 14:05:16.000000

  SCN: 47.585684388

  Current write position:

  Sequence #: 9

  RBA: 5495173

  Timestamp: 2019-03-14 14:05:10.720580

  Extract Trail: ./dirdat/cb

Sending STATUS request to EXTRACT E_RC_173 ...

EXTRACT E_RC_173 (PID 28210)

  Current status: Recovery complete: At EOF

  Current read position:

  Redo thread #: 1

  Sequence #: 13097

  RBA: 1708173824

  Timestamp: 2019-03-14 14:05:16.000000

  SCN: 47.585684779

  Current write position:

  Sequence #: 18154

  RBA: 61697113

  Timestamp: 2019-03-14 14:05:16.497692

  Extract Trail: ./dirdat/cc



之前6号的文件还在，6号之前的被我手动删除了

oracle@odb-wx045-s172:goldengate$ ls -l /data/goldengate/dirdat/cc* 

-rw-rw-rw- 1 oracle oinstall 99999945 Mar  6 15:51 /data/goldengate/dirdat/cc017708

-rw-rw-rw- 1 oracle oinstall 99999830 Mar  6 15:51 /data/goldengate/dirdat/cc017709

-rw-rw-rw- 1 oracle oinstall 99999749 Mar  6 15:51 /data/goldengate/dirdat/cc017710

-rw-rw-rw- 1 oracle oinstall 99999270 Mar  6 15:51 /data/goldengate/dirdat/cc017711

-rw-rw-rw- 1 oracle oinstall 99999297 Mar  6 15:51 /data/goldengate/dirdat/cc017712

-rw-rw-rw- 1 oracle oinstall 99999806 Mar  6 15:51 /data/goldengate/dirdat/cc017713


暂无图片 评论
暂无图片 有用 0
章芋文

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

如果要使用自动清理就需要将抽取进程和投递进程的队列文件名改为不一样，或者将两边的队列文件序列号调整为相近。

暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
暂无图片墨值悬赏