RE: Restore from hot backup question

Hi Mike,
Yes, you can restore from the hot backup. And yes there is more to do. You will need to do an incomplete (or point in time) recovery till the point prior to the start of the data load process. You can do so by using backup controlfile and canceling the recovery after applying the last archived log before the data load process started. After that, you will need to open the database with resetlogs option. You should take another (preferably cold) backup before allowing anyone to use the database. This will render all previous backups useless (due resetting logs). So, taking a backup at this point is very critical.
Good Luck..

HTH.. Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Spragg, Mike [SMTP:Mike.Spragg_at_cignabehavioral.com]
> Sent: Friday, June 01, 2001 1:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Restore from hot backup question
>
> I have an 8.0.5 data warehouse database in archivelog mode. We run a hot
> backup nightly and afterwards we run data loads. Last nights loads
> corrupted the database. I want to restore the database to the point
> immediately after last nights hot backup. I have never had to do this
> type
> of restore. Can I simply restore all the datafiles, redo logs & control
> files from last nights backup and restart the database? Or is there more
> to
> it than that?
>
> Thanks - Mike Spragg
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Spragg, Mike
> INET: Mike.Spragg_at_cignabehavioral.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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).