From MATT.ADAMS@APPL.GE.COM Wed, 26 Sep 2001 12:32:29 -0700 From: "Adams, Matthew (GEA, 088130)" Date: Wed, 26 Sep 2001 12:32:29 -0700 Subject: RE: recovery Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: recovery The control files are all intact and the database is open. Only one datafile (for an offline tablespace) is missing. ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com Meddle not in the affairs of troff, for it is subtle and quick to anger. > -----Original Message----- > From: Gogala, Mladen [mailto:MGogala@oxhp.com] > Sent: Wednesday, September 26, 2001 4:27 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: recovery > > > It is correct if the files weren't renamed or physically > removed. In  that > case, you have > to re-create the controlfile and do recovery using backup > controlfile (which > means that it > doesn't have the target SCN). > > -----Original Message----- > Sent: Wednesday, September 26, 2001 4:05 PM > To: Multiple recipients of list ORACLE-L > > > > It's been a while for this scenerio for me. > > Other dba takes a tablespace offline to shuffle files > around.  Accidently nukes on of the files clear out of > exsistence.  DB is in archivelog mode. > > Recovery steps as I recall them. > > 1) get missing file from last backup > 2) Get needed archive log files from backup > 3) issue 'alter database recover tablespace blah' > > correct? > > > ---- > Matt Adams - GE Appliances - matt.adams@appl.ge.com > Meddle not in the affairs of troff, > for it is subtle and quick to anger. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gogala, Mladen >   INET: MGogala@oxhp.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@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). >