3 Replies Latest reply: Aug 7, 2013 11:46 AM by clcarter RSS

    Recover error ORA-00600

    9fecc3cc-b3c6-4cb6-b1d4-3a0c716c917c

      i try recover a oracle database xe with only dbf files, but teh database not open...

       

      SQL> startup

      ORACLE instance started.

       

      Total System Global Area  839282688 bytes

      Fixed Size                  2231136 bytes

      Variable Size             494929056 bytes

      Database Buffers          339738624 bytes

      Redo Buffers                2383872 bytes

      Database mounted.

      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

       

       

      SQL> alter database open resetlogs;

      alter database open resetlogs

      *

      ERROR at line 1:

      ORA-01194: file 1 needs more recovery to be consistent

      ORA-01110: data file 1: '/u01/app/oracle/oradata/XE/system.dbf'

       

       

      SQL> recover database using backup controlfile;

      ORA-00283: recovery session canceled due to errors

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

      [], [], [], [], []

       

       

      using _allow_resetlogs_corruption=TRUE

       

      ERROR at line 1:

      ORA-01092: ORACLE instance terminated. Disconnection forced

      ORA-00704: bootstrap process failure

      ORA-00600: internal error code, arguments: [2662], [0], [2149727], [0],

      [2150053], [4195105], [], [], [], [], [], []

      Process ID: 7026

      Session ID: 1 Serial number: 5