LogMiner Reports: krvrda.c:krvrdbrarSQL:Unknown missing colval .... Try turning on supplemental logging - ORA-01343 for Oracle "Capture" technology (Doc ID 1987949.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 to 12.1.3.0.0 [Release 12.1]
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

An error ORA-1343: "LogMiner encountered corruption in the logstream"
may be reported by one of next Oracle "Capture" technologies;


The Oracle database Alert log may show entries similar to:

Sun Mar 08 14:25:49 2015
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 109062, /u01/oradata/orcl/fast_recovery_area/DB101DB/archivelog/2015_03_08/o1_mf_1_109062_bhqtdtnc_.arc
Sun Mar 08 14:26:16 2015
<krvrda.c:krvrdbrarSQL>:Unknown missing colval SYSTEM.LOGMNR_PROPS$.NAME.
                     Try turning on supplemental logging.
Sun Mar 08 14:26:16 2015
<krvrda.c:krvrdadt_ApplyDDLTxn>: krvrdbrarSQL 109062.772261.60 1
Sun Mar 08 14:26:16 2015
LOGMINER: session#=1 (capture-name), builder MS01 pid=214 OS id=1824 sid=212 stopped
Sun Mar 08 14:26:16 2015
Errors in file /u01/app/oracle/diag/rdbms/db101db/orcl/trace/orcl_ms01_1824.trc:
ORA-01343: LogMiner encountered corruption in the logstream

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms