Re:RE: Rant

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