Sorry it took so long to get back to you; I've been caching the list for awhile and am just starting to catch up. :-)
Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users Beware!' Rich -- Rich Holland (913) 645-1950 SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"[EMAIL PROTECTED]"); > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > DENNIS WILLIAMS > Sent: Friday, November 07, 2003 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: full recovery > > Rich - Could you point to the place where Robert states that bit about > controlfiles to trace? Thanks. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Friday, November 07, 2003 1:59 PM > To: Multiple recipients of list ORACLE-L > > > I believe that an 'alter database backup controlfile to trace' loses the > RMAN data stored in the control files if you're not using a repository (if I > remember right from RF's book). > > Since we're not using a repository, we've got controlfile autobackup on (in > 9i use 'configure controlfile autobackup on'). We dump these disk copies > via filesystem backups as a safety measure. We also do a backup database, > archivelogs, and then control (but all in one step; I'm not sure I'm clear > on the reason for separating them into three backup sets).... > > Rich > -- > Rich Holland (913) 645-1950 SAP Technical Consultant > print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"[EMAIL PROTECTED]"); > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Mercadante, Thomas F > > Sent: Friday, October 24, 2003 2:35 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: full recovery > > > > > > AK, > > > > First, your normal backup should backup your database in the following > > order: > > > > Database, archivelogs and then control file. I actually do > > this in three > > separate Rman steps. This is so that the most recent control file is > > backups up after all of the data. This allows your to perform an > > incoimplete-recovery-restore to as late a time as possible. > > Also, consider > > adding a database trigger that, upon startup, perform an > > "alter database > > backup controlfile to trace;" Keep a copy of this trace file > > someplace safe > > as a sanity check. You could use it to recreate your > > controlfiles if all > > else fails. > > > > Your recovery steps are as follows: > > > > 1. restore oracle software from tape. > > 2. restore config files ( init.ora , listener. ora ). > > 3. startup instance with nomount. > > 4. run Rman to restore the control file from tape. > > 5. Alter database mount > > 6. run Rman to restore database files > > 7. alter database open resetlogs. > > 8. perform a brand-new Rman backup (database, logs & controlfile) > > > > turn the system back to the users (with many back-pats from > > management). > > > > You should be testing this on a regular basis. > > > > Good Luck! > > > > Tom Mercadante > > Oracle Certified Professional > > > > -----Original Message----- > > Sent: Friday, October 24, 2003 2:15 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Here is a scenerio : > > I am taking full database backup everynight using rman to tape . which > > includes archive logs and control file. Not using > > catalog.Also have a backup > > of complete file system including oracle software and > > configuration files ( > > init.ora , listener.ora etc.. ) > > I lost the host on a particular day at 12 am afternoon. Now I want to > > restore this db to latest possible time to another host ( > > with same name ) > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rich Holland > 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: Rich Holland 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).