yea the last question was rhetorical, i'd forgotten to back up the control file, a hole in my backup strategy.
joe DENNIS WILLIAMS wrote: >Joe - You da man. An impressive tour de force in working around RMAN. Was >your last statement rhetorical? I think you answered that question - that >you didn't have the right control file. Impressive that you were able to >creatively work around the obvious limitation. This is the reason we test >recovery scenarios, so that before the real disaster you've figured out that >you need to back the control file up separately. Congratulations. > > > >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > >-----Original Message----- >Sent: Thursday, October 03, 2002 8:23 PM >To: Multiple recipients of list ORACLE-L > > >Ok so the qa environment we've been fooling around with rman for testing >backup/recovery. > >tonite they say " we want a backup restored from rman from 2 incarnations >ago(for those of u who dont know what an incarnation is, its a new version >of the database that gets created when you do open resetlogs <-- if thats >wrong please RMAN gurus correct me. > >So I get out the book, the docs say "in the event you have to do this, which >should be rare", you must do the >"reset database to incarnation" command. > >seems easy enough, fire up rman, startup nomount, reset incarnation and it >finds the old backups, and starts the restore. > >so far so good, but then the catch, being a rman newbie(8.1.7), i forgot to >make a controlfile backup, now if i'd had that, this should have been >cake,restore the control file in nomount mode, mount and restore the >datafiles, recover the datafiles and open resetlogs, did i forget to say, >this is a NOARCHIVELOGMODE database. > >Well, for whatever reason, the database wouldnt open, due to using a newer >controlfile. > >hmmm, i've done this before, i'll just dump the controlfile to trace(yes i >did this BEFORE the restore, just in case of an actual emergency). > >rebuild the control file, try the recover again(did i say we're going to a >particular SCN based on the info from list backup/list incarnation >commands), no deal, damn database will not open. > >regroup, wait a minute, rman aint anything special, let's do this: > >restore the files from rman backup again. >exit rman >sqlplus: recover database until scn #######; >alter database open resetlogs; > >rman: <check> resync catalog; > >CHOKE, but i expected that, >rman: reset database; > >full catalog sync AND > >we're good to go. > >Where did go wrong in using RMAN to do the recover/restore ??? > >joe > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).