Barbara, I'm going to take a bit of a guess here - but this should work:
set aside the control files used when the database was opened normally. grab only the control files from the cold backup set (ideally a backup control file) or earlier and re-attempt recovery. I'm assuming that the size of the database is large. If not, restore the entire set and attempt recovery again. This is where snapshots on a higher-end storage volume are pretty sweet. hth, Paul "Baker, Barbara" wrote: > > Doh! > Your message came minutes after I'd already opened the database. > When I attempt the recovery I get the message > SVRMGR> recover database until cancel using backup controlfile; > ORA-00279: change 278038264 generated at 11/01/01 01:28:13 needed > for thread 1 > ORA-00289: suggestion : > /u14/oradata/ent/arch/arch.logentarch16551.dbf > ORA-00280: change 278038264 for thread 1 is in sequence #16551 > ORA-00283: recovery session canceled due to errors > ORA-00356: inconsistent lengths in change description > ORA-00353: log corruption near block 225 change 29240139592704 time > 10/31/01 01: > > Do you think this is because I did indeed already open the database > normally? Or do you think it's cuz I really do have bad archive files?? > > Thanks for your response. > Much appreciated. > Barb > > > ---------- > > From: Paul Drake[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Thursday, November 01, 2001 1:05 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: recover on different hardware > > > > otn - http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > > this site really sucks bad - half the links are broken. wtf? > > its 8.1.6 that's off of correction, not 8.1.7. > > my copy of 8i Backup recovery handbook is at the office, and the docs > > are not available online. > > > > > > most important: > > don't open the database normally after the restore > > > > startup mount exclusive > > <offline drop any datafiles that didn't make it to/from tape> > > <have all archived redo on disk in the log_archive_dest location> > > set autorecovery on > > recover database until cancel using backup controlfile; > > cancel > > alter database open resetlogs > > shutdown > > cold backup > > > > note: apparently, any read-only tablespaces should be offline while > > recovering using a backup controlfile. > > I had never heard of this, but stumbled across it while perusing the > > docs. > > > > > > "Baker, Barbara" wrote: > > > > > > Been here 18 hours. No database. Looks grim. > > > Hardware blew chunks. Major ugly. > > > Plan is to reconstruct entire system on new hardware. > > > If I get my dbf files from last night's cold backup (as well as all my > > > config files), I should have a database that looks just like last night > > at > > > 11:00 pm. > > > DB should come up clean, should think it's a happy camper. > > > > > > I do have most of my archived redo logs from today. What recovery > > option do > > > I use to start applying the redo logs I've been able to salvage? (Guess > > I'm > > > confused cuz the database will not think it needs recovery.) > > > > > > I'm about to RTFM, but I'm a bit bleary-eyed. > > > Any assistance greatly appreciated. > > > > > > Thanks! > > > Barb > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Baker, Barbara > > > 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). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Paul Drake > > 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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Baker, Barbara > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).