Large Trace Files with Error: ORA-08102: index key not found, obj# 9999, file 99 block 99999

========================================
General
========================================
Large trc files are being generated.

========================================
Evidences
========================================

alert.log

========================================

Wed Oct 24 05:48:16 2018
Trace dumping is performing id=[cdmp_20181024054816]
Wed Oct 24 05:49:24 2018
Errors in file /software/oracle/diag/rdbms/igt/igt/trace/igt_j000_12354.trc:
ORA-12012: error on auto execute of job 141
ORA-08102: index key not found, obj# 282, file 1, block 1969 (2)
Errors in file /software/oracle/diag/rdbms/igt/igt/trace/igt_j000_12354.trc:
ORA-12012: error on auto execute of job 141
ORA-08102: index key not found, obj# 282, file 1, block 1969 (2)
Wed Oct 24 05:49:25 2018
Trace dumping is performing id=[cdmp_20181024054925]
Wed Oct 24 05:50:33 2018
Errors in file /software/oracle/diag/rdbms/igt/igt/trace/igt_j000_12354.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 282, file 1, block 1969 (2)
ORA-12012: error on auto execute of job 141
ORA-08102: index key not found, obj# 282, file 1, block 1969 (2)
Wed Oct 24 05:51:32 2018

/software/oracle/diag/rdbms/igt/igt/trace/igt_j000_12354.trc

========================================
Trace file /software/oracle/diag/rdbms/igt/igt/trace/igt_j000_12354.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORACLE_HOME = /software/oracle/111
System name:    Linux
Node name:      col-com-1-aps-4
Release:        2.6.18-308.24.1.el5
Version:        #1 SMP Wed Nov 21 11:42:14 EST 2012
Machine:        x86_64
Instance name: igt
Redo thread mounted by this instance: 1
Oracle process number: 69
Unix process pid: 12354, image: oracle@col-com-1-aps-4 (J000)


*** 2018-10-24 05:50:30.185
*** SESSION ID:(462.12791) 2018-10-24 05:50:30.185
*** CLIENT ID:() 2018-10-24 05:50:30.185
*** SERVICE NAME:(SYS$USERS) 2018-10-24 05:50:30.185
*** MODULE NAME:() 2018-10-24 05:50:30.185
*** ACTION NAME:() 2018-10-24 05:50:30.185


*** TRACE FILE RECREATED AFTER BEING REMOVED ***


REDO RECORD - Thread:1 RBA: 0x0193ac.0001b6c7.0084 LEN: 0x15638 VLD: 0x09
SCN: 0x0db7.14fe2926 SUBSCN:  1 10/24/2018 05:42:57
CHANGE #1 TYP:2 CLS: 1 AFN:4 DBA:0x01017022 OBJ:153442 SCN:0x0db7.14fe27f4 SEQ:  1 OP:11.4 ENC:0
KTB Redo 
op: 0x01  ver: 0x01  
compat bit: 4 (post-11) padding: 1
op: F  xid:  0x000d.00f.0002be51    uba: 0x00c02523.1ef7.25
KDO Op code: LKR row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x01017022  hdba: 0x010073e2
itli: 2  ispac: 0  maxfr: 4858
tabn: 0 slot: 7 to: 2
CHANGE #2 TYP:0 CLS:41 AFN:3 DBA:0x00c00140 OBJ:4294967295 SCN:0x0db7.14fe277e SEQ:  2 OP:5.2 ENC:0
ktudh redo: slt: 0x000f sqn: 0x0002be51 flg: 0x0012 siz: 136 fbi: 0
            uba: 0x00c02523.1ef7.25    pxid:  0x0000.000.00000000
CHANGE #3 TYP:2 CLS: 1 AFN:4 DBA:0x0104f5c5 OBJ:153442 SCN:0x0db7.14a89d05 SEQ:  1 OP:11.5 ENC:0
KTB Redo 
op: 0x11  ver: 0x01  
compat bit: 4 (post-11) padding: 1
op: F  xid:  0x000d.00f.0002be51    uba: 0x00c02524.1ef7.01
Block cleanout record, scn:  0x0db7.14fe291b ver: 0x01 opt: 0x02, entries follow...
  itli: 6  flg: 2  scn: 0x0db7.14a89d05
KDO Op code: URP row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x0104f5c5  hdba: 0x010073e2
itli: 1  ispac: 0  maxfr: 4858
tabn: 0 slot: 0(0x0) flag: 0x0c lock: 1 ckix: 0
ncol: 42 nnew: 41 size: 0
col  0: [15]  37 33 32 31 30 31 31 37 30 39 34 32 35 30 34
col  2: [ 2]  c1 02
col  3: [ 2]  c1 02
col  4: [ 1]  80
col 41: [ 1]  80
CHANGE #83 TYP:0 CLS:26 AFN:3 DBA:0x00c1461c OBJ:4294967295 SCN:0x0db7.1511b877 SEQ:  7 OP:5.1 ENC:0
ktudb redo: siz: 84 spc: 4636 flg: 0x0022 seq: 0xfee7 rec: 0x08
            xid:  0x0005.004.0004e55f  
ktubu redo: slt: 4 rci: 7 opc: 11.1 objn: 43448 objd: 153442 tsn: 4
Undo type:  Regular undo       Undo type:  Last buffer split:  No 
Tablespace Undo:  No 
             0x00000000
KDO undo record:
KTB Redo 
op: 0x04  ver: 0x01  
compat bit: 4 (post-11) padding: 1
op: L  itl: xid:  0x000e.01b.0002b70d uba: 0x00c0df2a.1f14.08
                      flg: C---    lkc:  0     scn: 0x0db7.140c0dc8
KDO Op code: LKR row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x03014003  hdba: 0x010073e2
itli: 2  ispac: 0  maxfr: 4858
tabn: 0 slot: 8 to: 0
END OF DUMP REDO

*** 2018-10-24 05:50:33.287
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 282, file 1, block 1969 (2)
ORA-12012: error on auto execute of job 141
ORA-08102: index key not found, obj# 282, file 1, block 1969 (2)

========================================
Resolution
========================================

SQL> SELECT OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_TYPE 
       FROM DBA_OBJECTS 
      WHERE OBJECT_ID = '282';

OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE
------- ----------- -------------- --------------
SYS     I_JOB_NEXT                 INDEX


sqlplus / as sysdba
ALTER INDEX SYS.I_JOB_NEXT REBUILD ONLINE;