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.