How can I get the deleted files back?

[Tom Spence_1]

Hello team,

I was sooo scream that I deleted the 3 files (*.dbf) by someone asked me to remove it. 3 files are IMPORTANT for ORACLE. I wasn't aware of what extension (.dbf) is...

Help me, how can I undelete the files? Is there any way for me to undelete by dumping the disk? Or what? Hope I can able to take those back... Thanks!

-Tom

[Pete Randall]

Tom,

I'm afraid that you're going to have to restore them from a backup.

Pete

[Cheryl Griffin]

A data recovery specialist could help retrieve the files but this option might be costly.

Cheryl Griffin

[Hai Nguyen_1]

You have no other choice but restore them from your lastest backup.

Shutdown the DB, restore the .dbf files and try to recover the DB.
Hai

[Victor_5]

For HP-UX, no undelete, two ways for that:

1. restore it from backup

2. write a script, trying to keep the deleted file in a tmp directory, but this way does not help for your today's case 'cause it is too late.

[A. Clay Stephenson]

If the filesystem remained mounted for any period of time after the files were removed, it is almost certain that at least portions of the files have been overwritten. Data recovery is almost certainly doomed. It's time to restore from backup.

[Cheryl Griffin]

Here is one example of a Data Recovery Specialist:
http://www.ontrack.com/datarecovery/

Check for someone local as well.
Cheryl

[MANOJ SRIVASTAVA]

Hi Tom

There is no way you can recover the files , please get them back from the tapes.


Manoj Srivastava

[Thierry Poels_1]

Hi,

- as already mentioned recovery might be possible by specialized companies, but at a high price, rarely an option

- next, in a multi-user environment the diskspace freed might already be reused by another file, which makes an undelete impossible

- if you're lucky it were datafiles of the Temporary or Rollback Tablespace which *can* be recreated from scratch, or maybe a tablespace only containing indexes. This won't make the DBA really happy however.

This is going to be a nice test for your backup procedures ;)


FYI: next to the *.dbf extension, some Oracle files use the *.log extension, they are also not really good candidates for the rm command.

good luck,
Thierry.

[Jean-Luc Oudart]

Tom,

no later than yesterday I mentioned the 3 big words : backup... backup and backup.

I'm afraid you have no other solution than going back to previous backup.
If your archive mode is on you should be able to recover to the point of failure (or deletion in your case).
talk to your Oracle DBA (it's good to talk).

good luck,
JL

[Fragon]

Hi Tom, I did this before and tried to undelete the removed file through its superblock and inodes, but failed in HP-UX.
So I think that there is no good way to undelete the file but restore them from the tape!
If you have no these files' backup, then I must say sorry to you that...

-Gerald-

[Sanjay_6]

Hi Ton,

Restoring from the backup is your only choice.

Hope this helps.

Regds