| 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: Restore from hot backup question
Mike,
if you know EXACTLY when you want to restore to, you can do a point-in-time recovery.
No matter what, unless you had shutdown the database to do the backup, you cannot just restart it. You will have to run recovery to some point-in-time or archived log and then open the database using the resetlogs option. At that point, I'd take another backup, just to be safe.
Rachel
>From: "Spragg, Mike" <Mike.Spragg_at_cignabehavioral.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Restore from hot backup question
>Date: Fri, 01 Jun 2001 10:41:15 -0800
>
>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: Rachel Carmichael INET: carmichr_at_hotmail.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 Fri Jun 01 2001 - 14:19:34 CDT
 |
 |