OGG Extract / Replicat Checkpoint RBA Is Larger than Local Trail Size (Doc ID 1138409.1)
环境:
OS:Centos 6
DB:11.2.0.4
ogg:12.3.0.1
说明：从库突然宕机重启后导致
1.报错如下
计算公式:
New datapump / Replicat RBA = Reader's too-big checkpoint RBA(A) + First record RBA in the new trail file (after the restart abend)(B) - RBA of the matching record in the trail file referred in checkpoint file(C)
2.获取变量A
GGSCI (epidbhn) 2> info repep
REPLICAT REPEP Last Started 2024-06-17 13:34 Status ABENDED
Checkpoint Lag 00:00:05 (updated 04:48:31 ago)
Log Read Checkpoint File /u02/goldengate12c/dirdat/ep000013165
2024-06-17 11:44:15.346174 RBA 311832869
变量A=311832869
3.获取变量B
Logdump 29 >open ./dirdat/ep000013166
Current LogTrail is /u02/goldengate12c/dirdat/ep000013166
Logdump 30 >ghdr on
Logdump 31 >n
2024/06/17 13:34:19.672.633 FileHeader Len 1409 RBA 0
Name: *FileHeader*
3000 031c 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...
0006 3200 0004 2000 0000 3300 0008 02f3 4142 c5db | ..2... ...3.....AB..
4039 3400 001f 001d 7572 693a 686e 6a6d 6462 3032 | @94.....uri:hnjmdb02
3a3a 7530 313a 6f67 673a 505f 444d 4941 4f35 0000 | ::u01:ogg:P_DMIAO5..
2135 0000 1d00 1b75 7269 3a68 6e6a 6d64 6230 323a | !5.....uri:hnjmdb02:
3a75 3031 3a6f 6767 3a45 5854 4550 3600 0016 0014 | :u01:ogg:EXTEP6.....
2e2f 6469 7264 6174 2f65 7030 3030 3031 3331 3636 | ./dirdat/ep000013166
Logdump 32 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 0 (x0000) IO Time : 2024/06/17 13:34:05.849.750
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)
2024/06/17 13:34:05.849.750 RestartAbend Len 0 RBA 1417
Name:
After Image: Partition 0 G s
Logdump 39 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 81 (x0051) IO Time : 2024/06/17 13:34:19.829.668
IOType : 170 (xaa) OrigNode : 1 (x01)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
DDR/TDR Idx: (001, 000) AuditPos : 40534408
Continued : N (x00) RecCount : 1 (x01)
2024/06/17 13:34:19.829.668 Metadata Len 81 RBA 1479
Name:
3000 4d00 0100 0200 0100 0200 3700 0100 0400 ea27 | 0.M.........7......'
0000 0200 0400 0100 0000 0300 0200 0000 0400 0500 | ....................
0300 474d 5405 0014 0010 0000 0014 1414 1414 1414 | ..GMT...............
1414 1414 1411 1414 1403 0008 0006 004a 484d 5944 | ...............JHMYD
42 | B
Logdump 46 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 5920 (x1720) IO Time : 2024/06/17 13:34:19.830.797
IOType : 170 (xaa) OrigNode : 2 (x02)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
DDR/TDR Idx: (001, 001) AuditPos : 40534408
Continued : N (x00) RecCount : 1 (x01)
2024/06/17 13:34:19.830.797 Metadata Len 5920 RBA 1611
Name: HXL.TB_JZ
3040 1a17 0000 0100 0200 0b00 0200 4000 0100 0600 | 0@............@.....
0100 0200 0500 0200 0400 0000 0000 0300 0200 0000 | ....................
0400 0200 0000 0500 0800 0000 0000 0000 0000 0600 | ....................
0400 0000 0000 0700 0200 0000 0800 0400 0000 0000 | ....................
0340 ca16 0000 4a00 4900 3500 0700 4348 494c 444e | .@....J.I.5...CHILDN
4f00 000e 0000 000e 0000 000e 0000 0000 0000 0000 | O...................
0000 0000 0000 00ea 2700 0060 0000 0000 0000 0000 | ........'..`........
变量B=1479(RestartAbend后的第一个rba)
4.变量C
2024-06-17 13:34:19 ERROR OGG-01705 Input checkpoint position 311832869 for input trail file '/u02/goldengate12c/dirdat/ep000013165' is greater tha
n the size of the file (281006080). Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.
变量c=281006080
5.公式计算
计算新进程RBA:
311832869+1479-281006080=30828268
6.启动复制进程
alter rep repep, extseqno 13166, extrba 30828268
