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:[EMAIL PROTECTED]] > 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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > http://www.inplan.de <http://www.inplan.de> > > > > > > -- > =============================================================== > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
