I see in 9ir2, you can autbackup the control file and can restore it as a standalone before even mounting the db, then you can mount the db and start the restore process.
thanks for the info, the experimentation continues :) joe DENNIS WILLIAMS wrote: >Joe - I have been working on a disaster test for RMAN so we can quit doing >weekly cold backups. I assumed the same as you, that RMAN writes its most >recent information to the control file as well as the catalog (there is a >retention parameter, so watch that). I tested no catalog recovery (just the >control file) with a small practice database and it worked fine. Then I >tried it with one of our production databases (recovering on a test system). >RMAN ran for awhile, creating data files, and then stopped. I didn't get >that issue debugged. Instead on my next try I loaded the RMAN catalog and >went that route. Got interrupted on another project and haven't gotten back >to it. > One thing I have learned from disaster recovering RMAN is that you need >to write a copy of the control file to the backup tape. While RMAN will >backup the control file, it can't create it if there is no control file >present. RMAN must first mount the database and it can't do that unless the >control file is there. Once it has the database mounted, then RMAN can >refresh the control file. > My experience applies to Oracle 8.1.6, using disk file backups. >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > >-----Original Message----- >Sent: Thursday, August 08, 2002 2:57 PM >To: Multiple recipients of list ORACLE-L > > >I've tested this and it works, i'm looking for verification of theory. > >1. built 2nd db for repository. >2. built repository and registered db >3. full backup via rman. >4. disconnect from RMAN >5. reconnect only to target >6. shutdown/startup mount target >7. restore database. > It states, using controlfile. >8. recover database. > > >all looks good. my question is even though i'm using a catalog during my >backup and simulate a total loss of that db by NOT connecting to a catalog >during restore, it was able to get the info from the control file. > >IS this default behavior, that when using RMAN, the control file is ALWAYS >written to even if a catalog is being used during the backup phase? > >Is this a safety net for those who might not be backing up their repository >database? > >thanks, joe > >ENV: linux rh 7.3, oracle 9.2.0.1 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
