Email: service@parnassusdata.com 7 x 24 online support!

    You are here

Oracle UNABLE TO OPEN DATABASE DUE TO ORA-600 [KRSCINT.NO_CUR_LOG]

Oracle UNABLE TO OPEN DATABASE DUE TO ORA-600 [KRSCINT.NO_CUR_LOG]

UNABLE TO OPEN DATABASE DUE TO ORA-600 [KRSCINT.NO_CUR_LOG]
PROBLEM:
--------
Unable to open a 3 node RAC database.
 
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-600: internal error code, arguments: [krscint.no_cur_log], [], [], [],
 
2011-06-24 11:46:28.613615 : Start recovery for domain=0, valid=0, flags=0x4
 parallel recovery setup failed: using serial mode
Thread 2 checkpoint: logseq 943, block 2, scn 20556318
    on-disk rba: logseq 943, block 76146, scn 20753135
Starting CRASH recovery for thread 2 sequence 944 block 1
Thread 2 current log 3
Scanning log 3 thread 2 sequence 943
Scanning log 4 thread 2 sequence 0
Cannot find online redo log for thread 2 sequence 944
Incident 60380 created, dump file: 
/u01/sq/ora_1/oracle/diag/rdbms/pmeidvsy/pmeidv1/incident/incdir_60380/pmeidv1
_ora_18730_i60380.trc
ORA-600: internal error code, arguments: [krscint.no_cur_log], [], [], []
SQL> select * from gv$log;
 
INST_ID GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# 
FIRST_TIME
1 7 1 945 104857600 2 NO ACTIVE 20753072 23-06-11 14:23:49
1 2 1 944 104857600 2 NO INACTIVE 20556322 23-06-11 00:50:29  <----!!!
1 1 1 943 104857600 2 YES INACTIVE 20555978 23-06-11 00:48:50
1 8 1 942 104857600 2 YES INACTIVE 20209449 22-06-11 01:38:27
1 3 2 943 104857600 2 NO CURRENT 20556318 23-06-11 00:50:27
1 4 2 0 104857600 2 YES UNUSED 0 23-06-11 00:49:01
1 5 3 957 104857600 2 NO CURRENT 20753071 23-06-11 14:23:49
1 6 3 956 104857600 2 NO INACTIVE 20556331 23-06-11 00:50:35
 
SQL> select * from gv$logfile;
 
INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_
1 1 ONLINE +REDO01/pmeidvsy/onlinelog/group_1.465.750850609 NO
1 1 ONLINE +REDO02/pmeidvsy/onlinelog/group_1.465.750850609 NO
1 2 ONLINE +REDO01/pmeidvsy/onlinelog/group_2.466.750850611 NO
1 2 ONLINE +REDO02/pmeidvsy/onlinelog/group_2.466.750850613 NO
1 7 ONLINE +REDO01/pmeidvsy/onlinelog/group_7.471.750850625 NO 
 
WORKAROUND:
-----------
none
 
RELATED BUGS:
-------------
BUG 8409848 - CRASH RECOVERY FOREGROUND DOES NOT CONNECT TO SYNC DESTINATIONS
which looks to have added this ORA-600
 
REPRODUCIBILITY:
----------------
Reproducable for the cst atwill
 
TEST CASE:
----------
 
STACK TRACE:
------------
- ORA600krs_20110624115359_COM_1.zip : Incident package
- info.html : V$DATABASE, V$LOG and V$LOGFILE info
- Tracefile with a DUMP of the logfiles
  SQL> alter system dump logfile 
'+REDO01/pmeidvsy/onlinelog/group_2.466.750850611';
     alter system dump logfile 
'+REDO02/pmeidvsy/onlinelog/group_2.466.750850613';