OGG的Replicat Checkpoint RBA和Local Trail Size

最新推荐文章于 2022-01-28 17:31:17 发布

msdnchina

最新推荐文章于 2022-01-28 17:31:17 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/msdnchina/article/details/54767357

Oracle GoldenGate 专栏收录该内容

101 篇文章

订阅专栏

本文探讨了当 OGG Replicat 的 Checkpoint RBA 大于本地轨迹文件大小时的问题及解决方案。这种情况通常发生在系统故障后，Replicat 在读取轨迹文件时会遇到错误。对于不同版本的 OGG，提供了不同的解决方法。

请参考如下两个文章:

OGG Replicat Checkpoint RBA Is Larger than Local Trail Size- Ogg v11.2 (Doc ID 1536741.1) ---适用于OGG v11.2 的版本

From OGG v11.2.1.07 onwards we have a new command to start the replicat if the issue is encountered 
and so we could avoid the calculations that needs to be done as explained in the primary KM - 1138409.1

OGG Extract / Replicat Checkpoint RBA Is Larger than Local Trail Size (Doc ID 1138409.1)---适用于OGG小于11.2的版本.

至于Replicat Checkpoint RBA 大于 Local Trail Size 的原因,见下:
After a system outage, a Replicat could get abended with the following error message. This issue occurs when the replicat read checkpoint RBA is larger than the local trail file size that it reads.

2011-11-28 07:51:36 ERROR OGG-01705 Input checkpoint position 160374765 for input trail file '/ogg-data/ogg/itmscmp/rmtdir/pe027505' is greater 
than the size of the file (160301092). Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.