ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]

  • From: Zhou Huan <patriotzhou@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 23 Oct 2010 23:51:40 +0800

Hi Guys,

My system shutdown abnormally due to power.
Now the database not able to open, it prompt:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[43], [17448], [17450], [], [], [], [],
 [], [], []
I searched google, but no solution. Any advise?
Thank you.

This is the trace file:
Trace file /u01/app/oracle/diag/rdbms/sorcl/sorcl/trace/sorcl_ora_993.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name:    SunOS
Node name:      solaris
Release:        5.10
Version:        Generic_142910-17
Machine:        i86pc
Instance name: sorcl
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 993, image: oracle@solaris (TNS V1-V3)


*** 2010-10-23 23:21:14.491
*** SESSION ID:(125.7) 2010-10-23 23:21:14.491
*** CLIENT ID:() 2010-10-23 23:21:14.491
*** SERVICE NAME:() 2010-10-23 23:21:14.491
*** MODULE NAME:(sqlplus@solaris (TNS V1-V3)) 2010-10-23 23:21:14.491
*** ACTION NAME:() 2010-10-23 23:21:14.491

Successfully allocated 2 recovery slaves
Using 66 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 43, block 2, scn 1818123
  cache-low rba: logseq 43, block 16705
    on-disk rba: logseq 43, block 17450, scn 1825373
  change track rba: logseq 43, block 17448, scn 1825364
  start recovery at logseq 43, block 16705, scn 0

*** 2010-10-23 23:21:14.515
Started writing zeroblks thread 1 seq 43 blocks 17448-17455

*** 2010-10-23 23:21:14.517
Completed writing zeroblks thread 1 seq 43
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 371Kb in 0.02s => 18.14 Mb/sec
Longest record: 0Kb, moves: 0/1232 (0%)
Change moves: 2/48 (4%), moved: 0Mb
Longest LWN: 87Kb, moves: 0/90 (0%), moved: 0Mb
Last redo scn: 0x0000.001bda4d (1825357)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 170/170 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 2116/2354 = 0.9
----------------------------------------------
WARNING! Crash recovery of thread 1 seq 43 is
ending at redo block 17448 but should not have ended before
redo block 17450
Incident 8554 created, dump file:
/u01/app/oracle/diag/rdbms/sorcl/sorcl/incident/incdir_8554/sorcl_ora_993_i8554.t
rc
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[43], [17448], [17450], [], [], [], [],
 [], [], []

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[43], [17448], [17450], [], [], [], [],
 [], [], []
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[43], [17448], [17450], [], [], [], [],
 [], [], []

*** 2010-10-23 23:23:29.757
Stopping background process MMNL

*** 2010-10-23 23:23:30.757
Stopping background process MMON

*** 2010-10-23 23:23:31.859
ksukia: Starting kill, flags = 1
ksukia: killed 0 out of 0 processes.
*** 2010-10-23 23:23:31.984 4132 krsh.c
ARCH: Archival disabled due to shutdown: 1089

*** 2010-10-23 23:23:33.039
*** 2010-10-23 23:23:33.039 4132 krsh.c
ARCH: Archival disabled due to shutdown: 1089
-- 
Best Regards
Zhou Huan
 <patriotzhou@xxxxxxxxx>

Other related posts: