Email: [email protected] 7 x 24 online support!
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';