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