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