Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Delete Datafile and Recover DB Without Using Backup?
Hi Juan,
Thanks for the reply. I believe Windows does not let you delete a file opened for read/write by another process. Try it on a test db.
Also, lets assume that you don't have access to some of these utilities.
Digging a little deeper into Metalink, I found this note <246325.1> which discusses a recovery scenario described in my original post but it uses RMAN and Oracle 10g.
I'm assuming pre-10g and no RMAN.
-- mohammed --- Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:Received on Thu Feb 24 2005 - 15:47:37 CST
> Hi I don't have idea of unix, but in windows there
> is several
> utilities to undelete files, like rdisk.
> But if another datafile grows and take the space was
> used for that
> file, then you lost every thing.
> So is possible using one of that utilities.
__________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- http://www.freelists.org/webpage/oracle-l