Re: URGENT: need help by point in time recovery

On Fri, Feb 15, 2002 at 10:03:48AM -0800, Dejam, Ruth wrote:
> 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.

neat, is it as easy as I stated, just dropping out the ts you don't want. I guess I was thinking when the redo was applied it might barf, but I wasn't sure. Does the recovery just skip over the entries it doesn't know about?

Any details on this would be appreciated. Thanks.

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

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