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

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24996904/viewspace-731962/，如需轉載，請註明出處，否則將追究法律責任。