环境:
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 | [email protected] 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
标签：Replicat,0000,17,Larger,0200,06,x00,Local,RBA From： https://www.cnblogs.com/hxlasky/p/18253454