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.