PURGEOLDEXTRACTS 不能自动删除

最新推荐文章于 2023-03-03 15:09:38 发布

DBrabbit

最新推荐文章于 2023-03-03 15:09:38 发布

阅读量2.8k

点赞数 1

分类专栏： GoldenGate 文章标签： PURGEOLDEXTRACTS 自动删除

本文链接：https://blog.csdn.net/zhuxiaoliao/article/details/43202325

版权

最近一直被一个问题困扰，在ogg的source端无论如何也无法自动purge，终于解决了！

之前一直纠结在checkpoint上，但是真心不是，因为target可以自动删除，百思不得解。

参考了mos的一篇文档，好久没用竟然忘了mos....
In this Document
Symptoms
Cause
Solution
References
APPLIES TO:

Oracle GoldenGate - Version 10.4.0.0 to 11.2.1.0.3 [Release 10.4.0 to 11.2]
Information in this document applies to any platform.
SYMPTOMS

Example

Trail files not being purged by the manager. The event parameter is correctly set as

PURGEOLDEXTRACTS ./dirdat/local/migration/jm/jm*, USECHECKPOINTS, MINKEEPDAYS 3

CAUSE

The cause is due to local and remote trails have same full path filenames. the remote trail number is much smaller than local one, and the remote one was used to check if the local one may be purged.