One question, don't you have to have the database in no mount state to recover the controlfile in 8i? You do in 8.0.x.
Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 10:24 AM > 9i Offers automated recovery of the control file. All you need to know is > where you are making your > control file backups to (tape or disk), and the DBID of the database you > wish to recover the control > file of. If you forget the DBID, not to worry because it's stored in the > file name of the backup > pieces that contain the control file so you can play around and find the > DBID that way. > > 9i RMAN is much easier in this respect than earlier RMAN versions. > > Still, even if you loose your control file in 8i, it's not too hard to > recover that control file > as long as you know where your backup pieces are. You just need to mount the > instance and use > dbms_backup_restore to recover the control file from the backup set. It's > perhaps not the most > straight forward method of doing this, but it works. > > Shameless plug - This is all documented in Oracle9i RMAN Backup and Recovery > by Oracle Press. :-) > > RF > > Robert G. Freeman > Technical Management Consultant > TUSC - The Oracle Experts www.tusc.com > 904.708.5076 Cell (it's everywhere that I am!) > Author of several books you can find on Amazon.com! > > > > -----Original Message----- > Sent: Thursday, January 09, 2003 8:54 AM > To: Multiple recipients of list ORACLE-L > > > Igor - Hopefully you won't lose your repository at the same time you lose > all your production database controlfiles. However, if that is happens, > hopefully you were outside the computer room at that moment. ;-) > So, you should be able to recover your repository and/or take a fresh > backup. > I should point out that even if you use an RMAN repository, the recovery > information is still stored in the control files, so you can still perform a > control file recovery. But Jared is correct that it is much more difficult > if you must try to recover the control file from the RMAN backup piece. That > is why I separately back up the control file (binary backup) after the RMAN > backup. I understand this is all much better in 9i. > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Thursday, January 09, 2003 7:49 AM > To: Multiple recipients of list ORACLE-L > > > Doesn't the same apply to database repository, when it's lost? > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 08, 2003 4:14 PM > > > > And how does one go about restoring a database when all control files > > are lost, and the only recovery data is stored in the control file? > > > > This doesn't sound very reasonable. > > > > Jared > > > > > > > > > > > > > > "Deshpande, Kirti" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 01/08/2003 11:44 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > cc: > > Subject: RE : RMAN Repository > > > > > > Joe, > > That's what I have heard (from 2 Oracle University > > Professors/Lecturers/Demonstrators). But no one would tell me when it may > > happen. We do not use RMAN (yet) so I did not pursue it further. > > > > - Kirti > > > > -----Original Message----- > > Sent: Wednesday, January 08, 2003 1:08 PM > > To: Multiple recipients of list ORACLE-L > > > > > > <snip> > > > > Obilgatory oracle statement/question: rumor has it by some instructors > > that RMAN repository is going away and only control file recoveries > > will be possible, truth or fiction? > > > > joe > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Deshpande, Kirti > > 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: > > 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: Igor Neyman > 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: Freeman Robert - IL > 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: Ruth Gramolini 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).
