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!

Restore my database from cold backup

945603Jul 14 2012 — edited Jul 24 2012
My 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2012
Added on Jul 14 2012
114 comments
4,194 views