Re: rman fun :), nightmare and long

When you are doing point-in-time recovery you have to use the backup controlfile anyway and start with a level 0 which has the backup controlfile and roll forward using incrementals or just the archivelogs. I don't know if this answers your question but I will be glad to try again with more info.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 04, 2002 9:53 AM

> The controlfile gets backed up automatically when you do a RMAN full
backup.
> I have been having a debate this morning regarding a situation where we
do
> weekly full backups using RMAN and and a daily RMAN "archivelog all delete
> input".
>
> I contend we should do a "archivelog all delete input INCLUDING
> controlfile". My colleague states that this is only of value for when all
> controlfiles are lost. (which we both agree is highly unlikely but
> possible).
>
> I am asured that if we had no controlfile available we could "restore
> controlfile" and it would go back to the copy it has which could be 1 week
> old and then roll forward (after calling restore database). RMAN would
apply
> any changes necessary (of which there would be none in this scenario) and
> create an updated copy of the current controlfile)
>
> So Joe, you only needed a copy of the control file because of the scenario
> you were running and you would not need to take a specific copy in the
> normal run of events? Is my understanding correct?. I know that no
> recovery/DR scenario can be considered normal but I am particularly
> interested if any situation where we need to recover from the last backup
> either a full database to a SCN or point in time or recover a single
> datafile
> Thanks
> John
>
>
> -----Original Message-----
> Sent: 04 October 2002 12:58
> To: Multiple recipients of list ORACLE-L
>
>
> Connor, my problem(fault) was I didnt make a copy of the control
> file(and in 8.1.7, you don't get it backed up by default like in 9i,
> right?).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: John.Hallas_at_vodafone.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).