| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Delete Datafile and Recover DB Without Using Backup?
If a Oracle datafile is removed from a file while the
instance is still running and the database is open, is
it possible to recover without using a backup before
shutting down the database?
Reason I ask is because someone I was talking with said that they knew of someone who had accomplished a recovery after an accidental removal of a datafile on unix by re-creating the datafile from the unix shell.
Also, I do remember some talk of this type of recovery on this forum sometime in the past. Something to the effect that the file is still there although the file pointer has gone, it is still mapped in memory.
So, is this possible? Wouldn't mind testing this out once I get my hands on a little unix test box.
--
mohammed
 |
 |