I want to restore a database from cold backup. I don't think the cold backup is

Consistent. It's the image of hard drive when other drive of the server crashed.

I did following steps successfully

ALTER DATABASE RECOVER DATAFILE SYSTEM01.DBF

ALTER DATABASE RECOVER DATAFILE UNDOTBS01.DBF

RECOVER DATABASE;

However when I get the following error messages when I try to startup the db

ALTER DATABASE OPEN

*

ERROR at line 1

ORA-01092: ORACLE instance terminated. Disconnection forced

Error message in trace file

Tue Jan 09 18:26:24 2007

Errors in file e:\Oracle\admin\athendb\udump\testdb_ora_2244.trc

ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists

And in testdb_ora_2244.trc it says

*** 2007-01-09 18:26:23.000

KCRA: start recovery claims for 0 data blocks

*** 2007-01-09 18:26:23.000

KCRA: buffers claimed = 0/0, eliminated = 0

ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists

I also took away UNDO part in pfile and spfile. As suggested in

http://www.dbasupport.com/forums/archive/index.php/t-44944.html

But it didn't help.

I am using Windows 2000 Version 5.0 Service Pack 4 and

Oracle9i Enterprise Edition Release 9.2.0.1.0.

Thanks in advance for any suggestion.

It's the Oracle internal progress..

If you request the Oracle company, this solution will not recommend..

They say, DUL util can only recover.

PRM-DUL can be DUL alternative:DBRECOVER for Oracle

DBRECOVER Recovery Options

For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.

When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.

Archive ParnassusData Blog Migration Archive