Brian - I'm still not clear on what you're trying to accomplish here. Usually I feel that RMAN has better information than I do. With automated systems like RMAN, trying to override them is usually not a good idea. I don't think there is a direct command to do what you ask. Some other ideas: Usually if the catalog database is down when you need to do a backup, then you simply manually trigger a backup later. If this is a nagging problem, I would consider shifting to control file backups. What if your catalog is unavailable when you need to do a recovery? Now that is a problem!! If you are concerned that the control file will have backup information the catalog won't, the first thing I would try is RESYNC CATALOG and see if the control file backups are populated to the catalog. Would be easy to try. If that doesn't work, you can manually add the control file backups to the catalog. Do you have Robert Freeman's book Oracle9i RMAN Backup & Recovery?
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, March 31, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I am using RMan with and without the Catalog... if the Catalog goes down..my backups and restores just switch to Nocatalog mode and keep on ticking.. My goal is to restore/recovery just a backup that resides on tape rather than accessing the Disk copies... I guess that Rman at least with the Catalog knows of both... What would the command be to only recover using the tape media backups...???? I think Rman doesn't directly give you that option(RTM)... so I was wondering if somebody knew a work around to Force RMAN and the Catalog to only recover from the Tape backups. Brian Spears -----Original Message----- Sent: Monday, March 31, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Brian - I couldn't figure out what you are asking. First of all, are you intending to use RMAN with a catalog? Are you wanting to distinguish the backups for a report or on recovery. I think that RMAN will record all the backups you have performed and will want to use the most recent backup for recovery. If it is just a report, you could use the "TAG" parameter when you perform backups so the disk backups and tape backups could easily be listed differently. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, March 31, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Anybody doing Rman Disk and MML tape backups ? Do you know how to force Rman just look at tape backups? (please no change the directory on disk answers.. just lookin to see if I can automate it at the command level.) Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian 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).