It's so much easier to include an "sql "alter database backup controlfile to <filename>";
in the rman script.
Backup the Database first.
Then backup the archive logs.
Then backup the controlfile.
Hemant
At 06:54 AM 18-09-03 -0800, you wrote:
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. [EMAIL PROTECTED]
-----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: [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: DENNIS WILLIAMS 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).
Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
