It’s been a long time since my last post here.
Well, the time has arrived. New GoldenGate runtime errors (lol):
ERROR OGG-02077 Extract encountered a read error in the asynchronous reader thread and is abending: Error code 1343, error message: ORA-01343: LogMiner encountered corruption in the logstream.
OK then, don’t worry.
Check database alert regarding messages about RFS retries. Wait until it stops, then try to restart GoldenGate Extracts.
It appears to be GG 12.2 bug and seems it fixes itself. There is no published MOS DOC regarding that so far.
Hope it solve your Extract errors too… \o/
Below errors are coming in alert log:
LOGMINER: Begin mining logfile for session 7 thread 1 sequence 13261, +DATADG/perfdb/redo02.log
:Unknown missing colval SYSTEM.LOGMNR_IND$.OBJ#.
Try turning on supplemental logging.
: krvrdbrarSQL 13262.433.96 1
krvxerpt: Errors detected in process 125, role builder.
krvxmrs: Leaving by exception: 1343
Errors in file /scratch/app/oracle/diag/rdbms/perfdb/perfdb2/trace/perfdb2_ms08_84804.trc:
ORA-01343: LogMiner encountered corruption in the logstream
LOGMINER: session#=6 (OGG$CAP_PM007AX), builder MS08 pid=125 OS id=84804 sid=258 stopped
Errors in file /scratch/app/oracle/diag/rdbms/perfdb/perfdb2/trace/perfdb2_ms08_84804.trc:
ORA-01343: LogMiner encountered corruption in the logstream
LOGMINER: End mining logfile for session 3 thread 2 sequence 5706, +FRADG/perfdb/archivelog/2019_04_09/thread_2_seq_5706.1810.1005173485
LOGMINER: Begin mining logfile for session 3 thread 2 sequence 5707, +DATADG/perfdb/redo03.log
LOGMINER: End mining logfile for session 3 thread 1 sequence 13261, +DATADG/perfdb/redo02.log
LOGMINER: Begin mining logfile for session 3 thread 1 sequence 13262, +DATADG/perfdb/redo05.log
I am not able to start extract process,Getting below error in ggserr.log
2019-04-13 07:27:25 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, PM009AX.prm: EXTRACT PM009AX started.
2019-04-13 07:27:25 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Recovery initialization completed for target file /scratch/ogguser/app/Produ
ct/12.2.1.2.0/oggcore_source/dirdat/PM009A/AA000000179, at RBA 1928, CSN 8780392775.
2019-04-13 07:27:25 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Output file /scratch/ogguser/app/Product/12.2.1.2.0/oggcore_source/dirdat/PM
009A/AA is using format RELEASE 12.2.
2019-04-13 07:27:25 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Rolling over remote file /scratch/ogguser/app/Product/12.2.1.2.0/oggcore_sou
rce/dirdat/PM009A/AA000000179.
2019-04-13 07:27:25 INFO OGG-05519 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Output trail file encryption: AES256.
2019-04-13 07:27:28 INFO OGG-14049 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Heartbeat record resolved.
2019-04-13 07:27:28 INFO OGG-03010 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Performing implicit conversion of column data from character set CESU-8 to U
TF-8.
2019-04-13 07:27:28 INFO OGG-01054 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Recovery completed for target file /scratch/ogguser/app/Product/12.2.1.2.0/o
ggcore_source/dirdat/PM009A/AA000000180, at RBA 1928, CSN 8780392775.
2019-04-13 07:27:28 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Recovery completed for all targets.
2019-04-13 07:27:29 ERROR OGG-02077 Oracle GoldenGate Capture for Oracle, PM009AX.prm: Extract encountered a read error in the asynchronous reader thread and is ab
ending: Error code 1343, error message: ORA-01343: LogMiner encountered corruption in the logstream.
2019-04-13 07:27:29 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, PM009AX.prm: PROCESS ABENDING.
What is wrong here.
Golden Gate Version:
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.160517 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160711.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jul 12 2016 00:52:24
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved.