Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN in NOCATALOG mode?
Denham
Whether you need to back up the control file depends on whether you can recover the database without it. On Oracle8i, I gave up trying to extract the controlfile from the RMAN backup, and simply back the controlfile up after the backup completes. Others on this list have reported they were able to extract the controlfile from the RMAN backup. I believe that on Oracle9i this is much improved. The important thing is that you validate your backup regularly because an untested backup can't be trusted.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, September 18, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
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: Denham Eva
INET: EvaD_at_TFMC.co.za
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).
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). Received on Thu Sep 18 2003 - 09:54:43 CDT