Re: Delete Datafile and Recover DB Without Using Backup?
- From: mkb <mkb125@xxxxxxxxx>
- To: Jeremiah Wilton <jeremiah@xxxxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 24 Feb 2005 18:56:27 -0800 (PST)
--- Jeremiah Wilton <jeremiah@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
