Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recovery without backup.
could this be used for a datafile point-in-time recovery? I was thinking if joe wanted to recover some data he trashed between backups, it might be cool to use this to recover to the log switch just before joe hit the return key. The recovery being done on a aux db, of course. the names have been changed to protect the innocent, sean.
On Wed, Aug 08, 2001 at 12:57:11PM -0800, Jeremiah Wilton wrote:
> For that, you have to have all the logs since the file was created.
> It is the same command you use to add a newly created datafile to a
> standby.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Wed, 8 Aug 2001, JOE TESTA wrote:
>
> > yea its been around a while, look at
> >
> > alter database create datafile, in the 817 docs its under the category:
> >
> > Re-Creating Datafiles when Backups Are Unavailable
> >
> > joe
> >
> >
> >
> > >>> cspence_at_FuelSpot.com 08/08/01 03:21PM >>>
> >
> > I don't know much about this feature, but someone mentioned in 8.1.7 you can
>recover a datafile even without a backup as long as you have a control file that knew
>about it and the archive logs.
> > Anyone give this a try? I am going to attempt this weekend on my test box.
> >
> >
> > "Do not criticize someone until you walked a mile in their shoes, that way when
>you criticize them, you are a mile a way and have their shoes."
> > Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax: (707) 885-2275
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- =============================================================== Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: stellr_at_stell.cns.vt.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 08 2001 - 15:54:02 CDT