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!

How can I recover data from a USERS01.DBF file?

695174Apr 7 2009 — edited Apr 8 2009
So I had a Hard Drive die and that took out the OS and the Oracle RDBMS Installation (Oracle9i Enterprise Edition, 9.2.0.6.0 on WinXP). Fortunately most of the data in the database (9.5GB worth) was in the USERS01.DBF file which was on another drive and unharmed. I was also able to salvage the CONTROL01.CTL file, but everything else from the database is corrupted and irretrievable.

I've just setup a new machine with the same version of Oracle and I created a brand new database with the same SID as before. I then tried to do:

SQL> alter tablespace users offline temporary;

Tablespace altered.

(then I swapped the USERS01.DBF file with the original one and then tried to recover it)

SQL> recover tablespace users;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 9: 'F:\ORAHOME\ORADATA\MYDB\USERS01.DBF'
ORA-01122: database file 9 failed verification check
ORA-01110: data file 9: 'F:\ORAHOME\ORADATA\MYDB\USERS01.DBF'
ORA-01206: file is not part of this database - wrong database id


Is it even possible to do what I'm trying to? I had no backup of the USERS01.DBF file, but there should be some way to get at the data that is inside it...

any help or a pointer in the right direction is much appreciated.

thanks
-jeff
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2009
Added on Apr 7 2009
2 comments
1,482 views