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.
On Thu, 24 Feb 2005 12:29:41 -0800 (PST), mkb <mkb125_at_yahoo.com> wrote:
> 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
>
>
> __________________________________
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
> http://promotions.yahoo.com/new_mail
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 24 2005 - 15:38:17 CST
