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).