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: [EMAIL PROTECTED]
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: [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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED]
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: [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.net -- Author: Craig Munday INET: [EMAIL PROTECTED]
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: [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).