Re: recover on different hardware

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:paled_at_home.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > 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: bakerb_at_rockymountainnews.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: paled_at_home.com
> >
> > 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: ListGuru_at_fatcity.com (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: bakerb_at_rockymountainnews.com
>
> 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: ListGuru_at_fatcity.com (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: paled_at_home.com

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: ListGuru_at_fatcity.com (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).