This discussion is archived
3 Replies Latest reply: Aug 7, 2013 9:46 AM by clcarter RSS

Recover error ORA-00600

9fecc3cc-b3c6-4cb6-b1d4-3a0c716c917c Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points