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