| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: recover on different hardware
Barb,
What Paul said -- Do NOT open the database normally. If you use the backup controlfile, Oracle presumes that the SCN's in the headers may or may not be in sync and will allow you to recover past the SCN in the controlfile. Presumes it's "fuzzy".
You have my sympathies, I've been there, done that and it ain't pretty.
let us know how it went
Rachel
--- Paul Drake <paled_at_home.com> wrote:
> 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: Rachel Carmichael INET: wisernet100_at_yahoo.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).Received on Thu Nov 01 2001 - 03:38:49 CST
 |
 |