Home » RDBMS Server » Backup & Recovery » How can I recover data from a USERS01.DBF file? (Oracle9i Enterprise Edition, 9.2.0.6.0, WinXP)
How can I recover data from a USERS01.DBF file? [message #396711] Tue, 07 April 2009 16:02 Go to next message
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
Re: How can I recover data from a USERS01.DBF file? [message #396712 is a reply to message #396711] Tue, 07 April 2009 16:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can't just swap datafiles with databases like that. I assume you don't have any backups from the previous database?
Re: How can I recover data from a USERS01.DBF file? [message #396719 is a reply to message #396712] Tue, 07 April 2009 17:01 Go to previous messageGo to next message
sscrub
Messages: 2
Registered: April 2009
Junior Member
Correct. No backups. Is there any way to get the data out from the existing DBF file?
Re: How can I recover data from a USERS01.DBF file? [message #396720 is a reply to message #396711] Tue, 07 April 2009 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
Rumor has it that Oracle has a utility which can extract data, but the fee in excess of $10,000.

How much is the data worth to you?
Re: How can I recover data from a USERS01.DBF file? [message #396725 is a reply to message #396719] Tue, 07 April 2009 17:29 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As BlackSwan said, there are tools to salvage data from corrupted files and will cost you.
Oracle has its own DUL (data unloader).
A third party implementation is DUDE ( http://www.ora600.be/ ).
Good luck!.
Previous Topic: RAC, ASM RMAN Backup Restore
Next Topic: Recover control file with no backup
Goto Forum:
  


Current Time: Tue Dec 06 12:36:44 CST 2016

Total time taken to generate the page: 0.09389 seconds