Re:RE: Rant

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.....

:)

dgoulet_at_vicr.com 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)" <mvergara_at_guidant.com>> 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: mvergara_at_guidant.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_at_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).> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: > INET: dgoulet_at_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_at_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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_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_at_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).