Restore my database from cold backup
945603Jul 14 2012 — edited Jul 24 2012My machine crashed.And I have my dbf,redo and control files are on another partışın.In addition to this,I have spfile,init,listener and tnsnames files.How can I restore my database again.I will install fresh copy of Oracle database 9.2 on another server.Then,I try to restore my database from dbf,redo and control files on the new installed oracle server.
-Firstly,I installed fresh copy of 9.2 version.
-Then I copied my dbf,control and redo files under oradata.Their locations are the same as the old one.My new machine hardware configuration is the same as the old one's.
-I also changed listener and tnsnames files.
While mounting database it gives error related with control files,but I fixed this error after creating new control file.
I mounted database but I couldn't open it.Now,it gives error undotbs01 block 9 datafile 2 corrupt in alert log.Then it disconnects from oracle while opening with alter database open resetlogs; command.
I also verify that using dbv file command undotbs01.dbf is not corrupt.
Pls help me.Thank you.
Esra