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

Posted by PDSERVICE on Jan 16, 2016 In

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';

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]