Re: Delete Datafile and Recover DB Without Using Backup?

From: Tim Gorman <tim_at_evdbt.com>
Date: Mon, 28 Feb 2005 01:57:12 -0700
Message-ID: <BE482AF8.23F17%tim@evdbt.com>

...your luck will have to extend as far as the session also having SYSDBA privileges, which is required to use the DBMS_BACKUP_RESTORE package...

And, if your RECID/STAMP combination points to tape media, then Shared Server (MTS) would be a hindrance, not an aid, as I believe that RMAN MMV "shared libraries" require "dedicated server".

on 2/24/05 6:11 PM, Jeremiah Wilton at 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=3D>file#,
> FNAME=3D>'datafile copy name',
> FULL_NAME=3D>a,
> RECID=3D>b,
> STAMP=3D>c
> );
> end;
>
> Can anyone think of a way to force this PL/SQL to be run in any open sess=
> ion without *being* that session?
>
> People please correct me if necc. on my PL/SQL and use of dbms_backup_res=
> tore.
>
> --
> Jeremiah Wilton
> ORA-600 Consulting
> Emergencies - Seminars - Hiring
> http://www.ora-600.net
>
>

>> -----Original Message-----
>> From: mkb [mailto:mkb125_at_yahoo.com]
>> 
>> 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?

>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 28 2005 - 09:54:10 CST