From deepakthapliyal@yahoo.com Wed, 26 Sep 2001 13:18:30 -0700 From: Deepak Thapliyal Date: Wed, 26 Sep 2001 13:18:30 -0700 Subject: Re:recovery Message-ID: MIME-Version: 1.0 Content-Type: text/plain alternatively instead of automatic u could also use recover database to accomplish same thing .. also another way in ur scenerio in case u dont have backup of file nuked is using the create datafile command and then rollforward .. using ur archives .. obviously u will need archives since the time the said file was first created .. deepak --- dgoulet@vicr.com wrote: > Matt, > > That's correct. Only one item you may want to > use the 'alter database > recover automatic tablespace ;' so that your > not prompted for each and > every log file. > > Dick Goulet > > ____________________Reply > Separator____________________ > Author: "Adams; Matthew (GEA; 088130)" > > Date: 9/26/2001 12:05 PM > > 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. > > > > > > > recovery > > > >

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: > INET: dgoulet@vicr.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). __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: deepakthapliyal@yahoo.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).