1. I have configured RMAN for controlfile autobackup, so that every DB backup produces a backup of the controlfiles and spfile as well. With these, I can easily recover from a loss of every single database file. I can't imagine why anyone wouldn't do it this way (reponses invited).
2. MetaLink states that the location of a backup file is embedded in the file itself, that it can't be used if it's moved to another location, and that this is a feature (yeah, right). On Unix, symlinks will do the trick; on Windoze, the suggested workaround is to back up the backup to another location that matches the one from which you want to use it. I ran into this when restoring a backup on another system that had a different drive layout; rather than backing up the backup, I just juggled drive letters. The lesson here is to ensure that your backup directories are configured and named consistently across all database servers. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Timothy > I will tell you what I've figured out. Perhaps someone else can > provide additional information. > > 1. Some people have reported success in extracting the control file > from the RMAN backup. I got stuck on the issue that RMAN wouldn't > function unless the target instance was up with STARTUP MOUNT, but I > couldn't mount the database > until I had a control file to mount. I finally gave up and took the > expedient of doing a separate SQL BACKUP CONTROLFILE statement, using > the RMAN backup directory. To perform a disaster recovery, I just move > my copy of the control file into position first. > > 2. I have not been able to convince RMAN to use a different backup > location. > Fortunately with Unix it is easy to create a link that looks like the > original location. > > > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Monday, June 30, 2003 10:35 AM > To: Multiple recipients of list ORACLE-L > catalo database > > > > Hi there everyone, > > I have read the documentation and I am missing something, I am stuck > on two > points: > > (1) How do I recover from a RMAN backup to disk if I have lost all > the > original database files (control files, data files and redo logs) > > (2) How do I change the location for RMAN to check for the backup up > file > i.e. Backup file was on E: but now in F:, when I enter restore it > only > checks the original location. > > > Specifications: > Oracle 8.1.7.4.10 > Windows 2000 SP4 > > > I know that in the backup part I can use the FORMAT string to specify > the > filename and location. > > > Cheers > Tim Clarkson > > -- > 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). __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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).
