Re: Delete Datafile and Recover DB Without Using Backup?

• Jeremiah Wilton <jeremiah_at_ora-600.net> wrote:

> What a great question.
>
> Here's an untested idea:
>
> 1) Find a running session (SQL*Plus?) that has the
> deleted datafile open (Unix lsof <file>), or if you
> are running Shared Server (MTS) just log in and hope
> to get a server process that has the file open.
>
> 2) In that session, run:
> declare
> a varchar2;
> b number;
> c number;
> begin
> sys.dbms_backup_restore.copydatafile (
> DFNUMBER=>file#,
> FNAME=>'datafile copy name',
> FULL_NAME=>a,
> RECID=>b,
> STAMP=>c
> );
> end;
>

Interesting. Hopefuly when I get my hands on a unix box, I can try this out.

You've also got me wondering if RMAN is doing something simliar as referenced in article 246325.1, at least conceptually.

In any case it seems, in theory at least, there should be ways to recover a file if accidently deleted from a unix filesystem without resorting to any sort of backup.

Now all we need to do is test it out. Can anyone out there try these out on one of your production systems please ;).

--
mohammed


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - 250MB free storage. Do more. Manage less. 
http://info.mail.yahoo.com/mail_250
--
http://www.freelists.org/webpage/oracle-l