RE: Database Down

>> I thought I would have to restore all datafiles and archive logs from
>> the physical backup so that they would be in sync, and then 'recover'
>> the database using the hot backup. This would only incur minimum data
>> loss since Saturday is a non-work day for most employees. After reading
>> the Backup and Recovery manual it looks like all I have to do is
>> 'recover' the database using the hot backup. Wouldn't it matter that
>> the datafiles would not currently be in sync since the datafiles on the
>> disk which did not crash were ok and not restored? Since the hot backup
>> would restore all the datafiles I would think it wouldn't matter.
>> Correct??

It is correct (except for the terminology - you are not doing recover using "the hot backup" but you are doing full (closed) datadase recovery). The data files that are being recovered can be checkpointed at different times, and oracle will apply appropriate logs to all the data files bringing all of them to the same (present if you have all the logs) point in time. Of course you have to have all the archived logs, or at least the archived logs that are generated after the last data file was checkpointed (in case you are missing some last logs, you would do incomplete recovery).

>> I would appreciate some second and third opinions. This is my first
>> 'live' recovery and I want to make sure as much as possible that I do
>> what will have the least impact on data loss. It goes without saying,
>> but I will have a complete backup of the 'good' disks before I tackle
>> this beast.

I would make the backup of all the files before the recovery (the ones restored from the tape, control files, good data files) as well, so that you do not have to restore them from the tape again in case something goes wrong with the recovery.

Djordje

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djordje Jankovic
  INET: djankovic_at_corp.attcanada.ca

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