OGG-01705 : Input checkpoint position 6926171 for input trail file ‘df000877’ is greater than the size of the file (6879012)

One of our server rebooted itself, the server is running with Oracle GG. after the server starts. Some of the replicats ABENDED.

 
2012-11-29 00:20:52  ERROR   OGG-01705  Oracle GoldenGate Delivery for Oracle, rqpusr.prm: 
Input checkpoint position 6926171 for input trail file '/home/oracle/ggs11/dirdat/eqpuser/df000877' is greater than the size of the file (6879012). 


Get the info of abended replicat. take note of the RBA.

  
GGSCI (exa2db01.bai.com) 2> info RQPUSR
 
REPLICAT   RQPUSR    Last Started 2012-11-29 01:40   Status ABENDED
Checkpoint Lag       00:00:00 (updated 02:25:30 ago)
Log Read Checkpoint  File /home/oracle/ggs11/dirdat/eqpuser/df000877
                     2012-11-29 00:01:12.001644  RBA 6926171
 
 
GGSCI (exa2db01.bai.com) 3>

Now check the filesize of trailfile where where the replicat abended..

  
-rw-rw-rw- 1 oracle oinstall 6879012 Nov 29 00:19 /home/oracle/ggs11/dirdat/eqpuser/df000877
-rw-rw-rw- 1 oracle oinstall 9999868 Nov 29 00:20 /home/oracle/ggs11/dirdat/eqpuser/df000878
-rw-rw-rw- 1 oracle oinstall 9999566 Nov 29 00:41 /home/oracle/ggs11/dirdat/eqpuser/df000879
exa2db01.bai.com: pexb1>

Now use Logdump utility to get the RBA right after the RestartAbend.
Open the next trail file where it abends.

 
exa2db01.bai.com: pexb1>./logdump
 
Oracle GoldenGate Log File Dump Utility
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
 
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
 
 
Logdump 181 >open /home/oracle/ggs11/dirdat/eqpuser/df000878
Current LogTrail is /home/oracle/ggs11/dirdat/eqpuser/df000878
Logdump 182 >ghdr on
Logdump 183 >n
 
2012/11/29 00:19:25.381.218 FileHeader           Len   990 RBA 0
Name: *FileHeader*
3000 01b5 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...
0002 3200 0004 2000 0000 3300 0008 02f1 f5ca b107 | ..2... ...3.........
7e62 3400 0020 001e 7572 693a 6462 7175 6970 3031 | ~b4.. ..uri:dbquip01
636e 633a 3a64 6250 5155 4950 3a67 6773 3131 3600 | cnc::dbPQUIP:ggs116.
002c 002a 2f68 6f6d 652f 6f72 6163 6c65 2f67 6773 | .,.*/home/oracle/ggs
3131 2f64 6972 6461 742f 6571 7075 7365 722f 6466 | 11/dirdat/eqpuser/df
3030 3038 3738 3700 0001 0138 0000 0400 0003 6e39 | 0008787....8......n9
 
Logdump 184 >n
___________________________________________________________________
Hdr-Ind    :     E  (x45)     Partition  :     .  (x00)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :     0  (x0000)   IO Time    : 2012/11/29 00:19:25.334.187
IOType     :   150  (x96)     OrigNode   :     0  (x00)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :          0       AuditPos   : 0
Continued  :     N  (x00)     RecCount   :     0  (x00)
 
2012/11/29 00:19:25.334.187 RestartAbend         Len     0 RBA 998
Name:
After  Image:                                             Partition 0   G  s
 
Logdump 185 >n
___________________________________________________________________
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :   281  (x0119)   IO Time    : 2012/11/29 00:01:05.000.678
IOType     :     5  (x05)     OrigNode   :   255  (xff)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :      27341       AuditPos   : 35849888
Continued  :     N  (x00)     RecCount   :     1  (x01)
 
2012/11/29 00:01:05.000.678 Insert               Len   281 RBA 1057
Name: QUIPUSER.SERV_ERROR_MESSAGE
After  Image:                                             Partition 4   G  s
0000 000c 0000 0008 3230 3039 3131 3732 0001 0024 | ........20091172...$
0000 0020 4d74 4570 d249 c066 b8d0 1e92 045b 2dab | ... MtEp.I.f.....[-.
b9c0 fbc9 e2b5 2b92 17e8 63e1 bea0 8f16 0002 004e | ......+...c........N
0000 004a 5c5c 6673 6732 3034 636e 635c 7175 6970 | ...J\\fsg204cnc\quip
5c32 3031 3231 3132 385c 3139 5c33 3662 6131 3764 | \20121128\19\36ba17d
3662 6438 3731 3664 6164 3132 3134 3031 3934 6463 | 6bd8716dad12140194dc
6434 3261 625c 7261 7765 7665 6e74 2e78 6d6c 0003 | d42ab\rawevent.xml..
 
Logdump 186 >

Below is the formula to get new RBA.

 
New datapump / Replicat RBA = (Reader's too-big checkpoint RBA) - (Actual size of datapump / replicat trail file (seqno X)) + First record in the new trail file (after the restart abend)

6926171 – 6879012 + 1057 = 48216

Using the same logdump session or create a new session to check if the result contains data.

 
Logdump 186 >pos 48216
Reading forward from RBA 48216
Logdump 187 >n
___________________________________________________________________
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :   297  (x0129)   IO Time    : 2012/11/29 00:01:12.001.563
IOType     :     5  (x05)     OrigNode   :   255  (xff)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :      27341       AuditPos   : 36053008
Continued  :     N  (x00)     RecCount   :     1  (x01)
 
2012/11/29 00:01:12.001.563 Insert               Len   297 RBA 48216
Name: QUIPUSER.SERV_ERROR_MESSAGE
After  Image:                                             Partition 4   G  s
0000 000c 0000 0008 3230 3039 3132 3230 0001 0024 | ........20091220...$
0000 0020 ad01 a644 a2c6 98c2 049e e91e d6e7 1e03 | ... ...D............
3833 8b3e 4482 0fe6 f99d 3df8 aaf6 7f58 0002 004e | 83.>D.....=....X...N
0000 004a 5c5c 6673 6732 3034 636e 635c 7175 6970 | ...J\\fsg204cnc\quip
5c32 3031 3231 3132 385c 3139 5c61 3838 6565 3463 | \20121128\19\a88ee4c
6666 6537 3133 6539 3461 3637 6239 6632 6665 3165 | ffe713e94a67b9f2fe1e
3137 3337 325c 7261 7765 7665 6e74 2e78 6d6c 0003 | 17372\rawevent.xml..
 
Logdump 188 >
 

alter rep RQPUSR, extseqno 878, extrba 48216
start RQPUSR

DONE!!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s