OGG-08533 & OGG-02188 Oracle GoldenGate Distribution Server for Oracle:

Symptom:
2020-01-15T21:45:13.896+0000 INFO | INFO OGG-01052 Oracle GoldenGate Distribution Server for Oracle: No recovery is required for target file /trail/TT000000000, at RBA 0 (file not opened). (DISTPATH01)
2020-01-15T21:45:13.908+0000 INFO | INFO OGG-02243 Oracle GoldenGate Distribution Server for Oracle: Opened trail file /trail/target/TA000000110 at 2020-01-15 21:45:13.908222. (DISTPATH01)
2020-01-15T21:45:13.908+0000 INFO | INFO OGG-01478 Oracle GoldenGate Distribution Server for Oracle: Output file /trail/TT is using format RELEASE 12.3/18.1. (DISTPATH01)
2020-01-15T21:45:13.911+0000 INFO | INFO OGG-05520 Oracle GoldenGate Distribution Server for Oracle: Input trail file encryption: AES256. (DISTPATH01)
2020-01-15T21:45:13.911+0000 INFO | Input Handler readLCR() return 509: (DISTPATH01)
2020-01-15T21:45:13.911+0000 ERROR| DS Handlers errors out: input handler error (4) (DISTPATH01)
2020-01-15T21:45:13.911+0000 ERROR| ERROR OGG-08533 Oracle GoldenGate Distribution Server for Oracle: Handler returned unexpected status ‘input handler error’. (DISTPATH01)
2020-01-15T21:45:13.911+0000 ERROR| Exception Code: OGG-08533 (DISTPATH01)
2020-01-15T21:45:13.911+0000 ERROR| Exception Message: Handler returned unexpected status ‘input handler error’. (DISTPATH01)
2020-01-15T21:45:13.911+0000 ERROR| Exception, killing the path DISTPATH01 (DISTPATH01)
2020-01-15T21:45:13.921+0000 WARN | Path killed. (DISTPATH01)
2020-01-15T22:05:46.374+0000 INFO | Using configured client REQUIRED authentication mode ‘client_server’ -> AuthenticateClient (nzosEstablishTrustInClient). (DISTPATH01)
2020-01-15T22:05:46.374+0000 INFO | Using configured server authentication mode: ‘client_server’ -> kAuthenticateServer (nzosEstablishTrustInTarget). (DISTPATH01)
2020-01-15T22:05:46.374+0000 INFO | Full security authentication as configured in effect. (DISTPATH01)
2020-01-15T22:05:46.374+0000 INFO | Negotiated cipher: 0x0067 – ‘TLS_DHE_RSA_WITH_AES_128_CBC_SHA256’. (DISTPATH01)
2020-01-15T22:05:47.418+0000 INFO | INFO OGG-01892 Oracle GoldenGate Distribution Server for Oracle: Distribution path network is configured as

……..

OS DEFAULT SPECIFIED ACTUAL VALUE
APP_FLUSHBYTES 27985 N/A 27985
APP_FLUSHSECS 1 N/A 1
IP_DSCP DEFAULT N/A DEFAULT
IP_TOS DEFAULT N/A DEFAULT
TCP_NODELAY 0 N/A 0
TCP_QUICKACK 1 1 1
TCP_CORK 0 N/A 0
SO_SNDBUF 16384 N/A 16384
SO_RCVBUF 87380 N/A 87380. (DISTPATH01)
2020-01-15T22:05:47.482+0000 INFO | INFO OGG-01052 Oracle GoldenGate Distribution Server for Oracle: No recovery is required for target file /trail/TT000000000, at RBA 0 (file not opened). (DISTPATH01)
2020-01-15T22:05:47.498+0000 INFO | INFO OGG-02243 Oracle GoldenGate Distribution Server for Oracle: Opened trail file /trail/target/TA000000110 at 2020-01-15 22:05:47.497360. (DISTPATH01)
2020-01-15T22:05:47.498+0000 INFO | INFO OGG-01478 Oracle GoldenGate Distribution Server for Oracle: Output file /trail/TT is using format RELEASE 12.3/18.1. (DISTPATH01)
2020-01-15T22:05:47.501+0000 INFO | INFO OGG-05520 Oracle GoldenGate Distribution Server for Oracle: Input trail file encryption: AES256. (DISTPATH01)
2020-01-15T22:05:47.501+0000 INFO | Input Handler readLCR() return 509: (DISTPATH01)
2020-01-15T22:05:47.501+0000 ERROR| DS Handlers errors out: input handler error (4) (DISTPATH01)
2020-01-15T22:05:47.501+0000 ERROR| ERROR OGG-02188 Oracle GoldenGate Distribution Server for Oracle: Unexpected LOB record or record fragment in /trail/target/TA000000110, rba 17,906. (DISTPATH01)
2020-01-15T22:05:47.501+0000 ERROR| Exception Code: OGG-02188 (DISTPATH01)
2020-01-15T22:05:47.501+0000 ERROR| Exception Message: Unexpected LOB record or record fragment in /trail/target/TA000000110, rba 17,906. (DISTPATH01)
2020-01-15T22:05:47.501+0000 ERROR| Exception, killing the path DISTPATH01 (DISTPATH01)
2020-01-15T22:05:47.516+0000 WARN | Path killed. (DISTPATH01)

Cause:
Goldengate Pump Is Abending With ERROR OGG-02188 Unexpected LOB record or record fragment in trail_file after altering it to start from RBA 0 of one particular trail file (Doc ID 2538787.1)
Need to Use logdump to find next possible good record and alter the pump to start it from the sequence and rba
logdump > ghdr on
logdump > ggstoken detail
logdump > detail data
logdump > sfh
Please note the rba and alter it to that
alter pump_name extseqno <seqno> extrba <rbano>

Solution:
Logdump
2020/01/04 15:28:09.333.172 FieldComp Len 84 RBA 31764
Name: dbo.tabl01 (TDR Index: 2)
After Image: Partition x0c e
4430 eee7 e4cb 6b69 52da 8b0a 0a7b 20a2 7d46 2774 | D0….kiR….{ .}F’t
026a 555a b84f b3bd af35 a370 d558 7c74 d43e 591b | .jUZ.O…5.p.X|t.>Y.
ac8c f463 2170 572b 9264 a7d9 a9d6 67e5 c5ee 6b5e | …c!pW+.d….g…k^
6603 40fb 5530 9d38 eff9 9efe 5c2b 99eb f5dd 47cb | f.@.U0.8….\+….G.
41bd 3342 | A.3B
Bad compressed block, found length of 59374 (xe7ee), RBA 31764
If the trail file is encrypted, set to use decryption on using decrypt command and rerun. If the decrypt command is used, wallet file or key name is incorrect, verify the encryption configuration.

alter DISTPATH01 begin seqno 0 rba 31764

Normal Log:

2020-01-15T21:56:50.339+0000 INFO | Using promiscuous client OPTIONAL authentication mode ‘clientOptional_server’ -> AuthenticateClient (nzosEstablishTrustInClient). (Thread 45)
2020-01-15T21:56:50.339+0000 INFO | Using configured server authentication mode: ‘clientOptional_server’ -> kAuthenticateServer (nzosEstablishTrustInTarget). (Thread 45)
2020-01-15T21:56:50.339+0000 INFO | Full security authentication as configured in effect. (Thread 45)
2020-01-15T21:56:50.351+0000 INFO | Negotiated cipher: 0x0067 – ‘TLS_DHE_RSA_WITH_AES_128_CBC_SHA256’. (Thread 45)
2020-01-15T21:56:50.377+0000 INFO | WebSocket request, handshake already sent. (Thread 45)
2020-01-15T21:56:50.377+0000 INFO | ThreadCtx contents Passive mode = 0, Sock = 3, DataLen = %?
?d (Thread 45)
2020-01-15T21:56:50.377+0000 INFO | Thread allocation successful ||| Sock = 3
||| Thread address 0x00007f9cd00111f0 (Thread 45)
2020-01-15T21:56:50.377+0000 INFO | Worker thread started (PATH-THREAD-21)
2020-01-15T21:56:50.377+0000 INFO | Current working directory: /u01/app/product/oggma/19.1.0.0.4 (PATH-THREAD-21)
2020-01-15T21:56:50.377+0000 INFO | Creating Handlers (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | RSInputHandler created, “wss://vmapmtcdhamerprdgg:16003”, fd = 3 (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Input Handler created (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Creating Message Handler (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Message Handler created (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Creating Output Handler (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Created Output Handler (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Handlers created successfully (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | Registering path in RSApplication (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | INFO OGG-01669 Oracle GoldenGate Receiver Server for Oracle: Opening /trail/TT000000000 (byte -1, current EOF 0). (PATH-THREAD-21)
2020-01-15T21:56:51.356+0000 INFO | INFO OGG-01670 Oracle GoldenGate Receiver Server for Oracle: Closing /trail/TT000000000. (PATH-THREAD-21)
2020-01-15T21:56:51.422+0000 INFO | INFO OGG-01669 Oracle GoldenGate Receiver Server for Oracle: Opening /trail/TT000000000 (byte -1, current EOF 0). (PATH-THREAD-21)
2020-01-15T21:56:51.445+0000 INFO | INFO OGG-01735 Oracle GoldenGate Receiver Server for Oracle: Synchronizing /trail/TT000000000 to disk. (PATH-THREAD-21)
2020-01-15T21:56:51.448+0000 INFO | INFO OGG-01670 Oracle GoldenGate Receiver Server for Oracle: Closing /trail/TT000000000. (PATH-THREAD-21)
2020-01-15T21:56:51.453+0000 INFO | Removing path in RSApplication (PATH-THREAD-21)

 

Leave a Reply

Your email address will not be published. Required fields are marked *