RE: RMAN in NOCATALOG mode?

All,

I also backup the control file as the last step within the backup and use the PL/SQL procedure within the documentation to restore the control file manually if needed - I think 9i has this in RMAN now.

I found this was necessary if you wanted to get the last change from your backup and the recovery catalog was not available for some reason. Also meant that I didn't have the extra work of restoring our recovery catalog during Disaster Recovery.

What is everyone's opinion on using the recovery catalog? I still have one configured because it records a lot more history (which I needed at one point), but is it really necessary?

Cheers,
Craig.

At 09:39 AM 18/09/2003 -0800, Mercadante, Thomas F wrote:
>me too. learned this from testing Rman back in 8.1.6. plus, you need this
>control file to recover from to get as late (most recent) timestamp as
>possible for recovery purposes.
>
>-----Original Message-----
>Sent: Thursday, September 18, 2003 11:45 AM
>To: Multiple recipients of list ORACLE-L
>
>
>I always backup the controlfile as a separate statement AFTER the back
>is done so hopefully the backup i just completed is in there :)
>
>joe
>
>
>Denham Eva wrote:
>
> >Hello
> >
> >Wondering about this. If backing up the database with RMAN in NOCATALOG
> >mode.
> >When would be the best time to do backup of the controlfile? Before backup
>/
> >after backup /before and after backup.
> >Does this aid your recovery from a crash? What advantage would it have?
> >
> >Many Thanks
> >Regards
> >Denham Eva
> >Oracle DBA
> >Linux like TeePee... No Windows, No Gates and Apache inside!
> >
> >
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Joe Testa
> INET: oracle-l_at_oracle-dba.com
>
>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.net
>--
>Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Munday
  INET: cmunday_at_bigpond.net.au

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