Restore from hot backup question

From: Spragg, Mike <Mike.Spragg_at_cignabehavioral.com>
Date: Fri, 01 Jun 2001 10:49:19 -0700
Message-ID: <F001.00318391.20010601104115@fatcity.com>

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). Received on Fri Jun 01 2001 - 12:49:19 CDT