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