OGG-01705 Input checkpoint position is greater than the size of the file

OGG-01705  Input checkpoint position is greater than the size of the file

 

1.1 问题描述

ERROR   OGG-01705  Input checkpoint position 66814523 for input trail file '/gglog/dirdat/rfpzx901/re000330' is greater than the size of the file (66732270).  Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.

 

1.2 问题分析

由于rep进程所在的机器突然down机，导致Input checkpoint position 66814523 for input trail file '/gglog/dirdat/rfpzx901/re000330' is greater than the size of the file (66732270)

 

1.3 问题处理

GGSCI (gddb10) 34> info RFPZX901  

 

REPLICAT   RFPZX901  Last Started 2011-12-30 23:56   Status ABENDED

Checkpoint Lag       00:00:00 (updated 15:09:55 ago)

Log Read Checkpoint  File /gglog/dirdat/rfpzx901/re000330

                     2011-12-30 19:28:33.750572  RBA 66814523

                    

 

--同时打开rep进程的handlecollisions参数

 

如果能用logdump来确定最后异常的数据的rba，则不用从0开始。当然从0开始比较保险，防止你定位错误而丢失了数据

GGSCI (gddb10) 35> alter rep RFPZX901, extseqno 000331, extrba 0

REPLICAT altered.

 

GGSCI (gddb10) 37> start RFPZX901

 

GGSCI (gddb10) 38> stats RFPZX901

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24996904/viewspace-731962/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24996904/viewspace-731962/