Re: RMAN QUestion

I'll bite

I don't have a clue about RMAN and you say it is a trick question. I think control files from time a and time b are the same and should work.

At 08:47 AM 6/21/2002 -0800, you wrote:
>
>
>Sorry, posted using wrong subject header, DUH!
>
>Use the following Exhibit to answer this question (note: This is not a
>hacked OCP question. This question
>came about out of the experience of one of our junior DBA's that I had to
>come in and figure out...Several
>Sr. DBA's that I know have gotten it wrong already... but we got some smart
>fokls here! :-)
>
>RMAN backup. Autobackup of control file is not enabled.
>
>Time a - Backup of database
>Time b - Archivelog Backups
>Time c - Drop tablespace
>Time d - Archivelog Backup
>
>To restore successfully, with RMAN (no manual fiddling) to time point b, you
>will first need to restore a control file. Which backup would you want to
>restore the control file from... (more than one answer may well be correct,
>I'm not telling).
>
>a. Control file from point a
>b. Control file from point b
>c. Control file from before point c
>d. Control file from after point c
>e. Control file from point d
>f. Recovery is not possible.
>
>I'll reveal the answer in the next 2 days...(and this *IS* a trick question,
>so
>think carefully).
>
>
>
>Robert G. Freeman - Oracle8i OCP
>Oracle DBA Technical Lead
>CSX Midtier Database Administration
>Author: Oracle9i New Features
>Mastering Oracle8i

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Monical
  INET: tech_at_restek.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).