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. [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).
RE: RMAN in NOCATALOG mode?
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).
Re: RMAN in NOCATALOG mode?
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).
Re: RMAN in NOCATALOG mode?
Hi! 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. In 9i RMAN you can configure controlfile autobackup on - that way RMAN always backs up controlfile as well during any backup. You just have to note that if you configure controlfile autobackup on, then this is remembered in controlfile and during several physical database operations like adding datafile, creating/dropping tablespace, taking tablespace/datafile online a controlfile backup is also created (default location $ORACLE_HOME/dbs or database). If you don't take it into account you could have hundreds of old controlfiles lying around if your environment involves a lot of physical structure changes (transportable tablespaces, read only/read write tablespaces etc). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
RE: RMAN in NOCATALOG mode?
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).
Re: RMAN in NOCATALOG mode?
No, controlfile is irrelevant as long as you got your physical structure somewhere (eg. controlfile trace) and all your redologs intact. You just recover using backup controlfile then (which means whatever controlfile you got, ignore it's checkpoint progress and other SCN information). That way you can recover to any point in time, providing that you recover all online datafiles to consistent SCN (you can't open a database recovered until SCN 1000 when one file has checkpoint SCN 1200 for example) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:39 PM 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: Tanel Poder 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).
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: [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).