mine have too... but as a generic rule, I'd wait until the backup was done, unless I trusted my SA
--- [EMAIL PROTECTED] wrote: > Rachel, > > You can say that if you want, I trust my SA's. And that they've > earned the > HARD way. > > Dick Goulet > > ____________________Reply Separator____________________ > Author: Rachel Carmichael <[EMAIL PROTECTED]> > Date: 7/22/2002 11:15 AM > > um, I'd schedule step 6 AFTER the backup finishes... I've seen idiot > SA's who start the backup then shutdown the machine or kill the > process > before it completes..... > > > :) > > > --- [EMAIL PROTECTED] wrote: > > I have, no fun. But at least your only fooling around with one > > tablespace > > and/or file vs. the entire database. The method is rather simple: > > > > 1) The tablespace/datafile are already offline, SMON does this > > for you > > unless it's SYSTEM in which case your not doing this in the first > > place. > > > > 2) Get your SA to restore the datafiles(s) from tape back to > > where they > > belong. > > > > 3) startup SQL*Plus as internal. > > > > 4) Alter database recover tablespace/datafile as you normally > > would. > > > > 5) Alter tablespace/datafile online. > > > > 6) Miller time. (After the SA schedules/starts a hot backup of > > the entire > > DB). > > > > Want to try one? Take a DB that's in archive log mode & either in > > development > > or test. Use production ONLY if your suicidal. Take the datafile > or > > tablespace > > offline for a little while. Now try to bring it back online. Then > > go to step 4 > > above. > > > > Dick Goulet > > > > ____________________Reply Separator____________________ > > Author: "Vergara; Michael (TEM)" <[EMAIL PROTECTED]> > > Date: 7/22/2002 8:13 AM > > > > I read your rant, and I agree with you. But I do have > > one little itsy bitsy question... > > > > > I also asked them how they'd put a tablespace in > > > backup mode. Simple enough, right? Not one of them > > > got it right. Not even close. Didn't have clue as to > > > what I was talking about. Fair enough, you don't > > > know. Well how about a simple recovery scenario. I > > > asked every candidate how they would do an online > > > recover of a datafile while the database was still in > > > use. No ideas. Not even close. > > > > How DO you do an online recovery of a datafile while the > > database is still in use? I've had to do recoveries before, > > but never this scenario. > > > > Thanks, > > Mike > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Vergara, Michael (TEM) > > 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: > > 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). > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: > 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). __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).