| How can I recover data from a USERS01.DBF file? [message #396711] |
Tue, 07 April 2009 16:02  |
sscrub
Messages: 2
Registered: April 2009
|
Junior Member |
|
|
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 pointers in the right direction is much appreciated.
thanks
-jeff
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
