RE: URGENT: need help by point in time recovery

We use that method for our 8.0.6 testing environments all the time. I don't know if it's supported but it's a really fast, easy way to get what you need.

> -----Original Message-----
> From: Ray Stell [SMTP:stellr_at_cns.vt.edu]
> Sent: Thursday, February 14, 2002 8:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: URGENT: need help by point in time recovery
>
>
> This reminds me of something I always wanted to try to work
> out. It seems like you should be able to rebuild part of a
> db, so that the recovery of a certain tables data would be
> faster. That way you don't spend the time reading all
> the datafiles for all the TS you don't need to recover.
>
> Could you just edit the trace control file to change the structure of
> the db, so that the only user TS is the one of interest?
>
>
>
> On Wed, Feb 13, 2002 at 12:32:09PM -0800, v.schoen_at_inplan.de wrote:
> > Hi list,
> >
> > I have a urgent problem. One of our developers has deleted all rows of a
> > table on production database (database of a customer from us). We have a
> > nightly cold backup and database is running in archivelog mode. On same
> > server we have a test instance which has same structure as prod
> instance,
> > only the folders are others. What I like to do is:
> >
> > 1. go to production and backup controlfile to trace
> > 2. copy the cold backup (production) from last night into this test
> instance
> > folders (datafiles, controlfiles...)
> > 3. copy archive logs of production to archive log folders from test
> > 4. startup testinstance nomaount
> > 5. create new controlfile with backuped controlfile from trace
> > 6. recover database until 'yyyy-dd-mm hh:........
> > 7. export deleted table and import it in production database
> >
> > My question is, if I make a clone of a database from a nightly cold
> backup,
> > can I recover the database with newer archivelogs. Or is there any other
> > method to get my data back (I don't have a actual export of database)?
> >
> > TIA
> >
> >
> > Volker Schoen
> > E-Mail: v.schoen_at_inplan.de <mailto:v.schoen_at_inplan.de>
> > http://www.inplan.de <http://www.inplan.de>
> >
> >
>
> --
> ===============================================================
> 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_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dejam, Ruth
  INET: Ruth.Dejam_at_voicestream.com

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).