Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot open database

user4478113Mar 22 2011 — edited Mar 22 2011
HI

OS :HP-UX PA RISC 11.23 / 64 bit
Oracle version : 10.2.0.1

I'm facing the unknown problem with my database. My old controlfie was missing the the datafile UNDO2.dbf and I have a bad backupset which cannot use it for restore. Then I recreated a new controlfile by using the current datafiles but UNDO2. It seemed to be OK until I open the database ( I'v created case on Oracle Metalink, they're working with that . I'm very thankful to all of your advices and hope that there are some experts here in this forum can help me out .

SQL>Startup nomount;
SQL@create_control.sql
SQL>alter database mount;
SQL>recover database;
--> success
SQL>ALTER DATABASE OPEN ;
Warning: Entry/Exit code is optimized. Cannot restore context (UNWIND 22)
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Here is content of alertlog file :
--->Internal error ORA-00600: internal error code, arguments: [25025], [24]

Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 23826
ORA-1092 signalled during: alter database open...

Best regard
Tien Lai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2011
Added on Mar 22 2011
3 comments
698 views