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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
