recovery

From: Basavaraja, Ravindra <Ravindra.Basavaraja_at_T-Mobile.com>
Date: Wed, 26 Mar 2003 14:33:37 -0800
Message-ID: <F001.00573C69.20030326143337@fatcity.com>

Hi,

I have to recover my database back to 23-MAR-03.There was some changes to the data yesterday and cannot be reverted. We want to recover the data as of 23-MAR-03.Database is running on archive log mode and I have the hot backup datafiles of Feb 3 and all the archive logs since then till today.I know how to recover but to make sure that I don't miss anything i am posting this here.

1.Restore the data tablespace datafiles from the Feb 3rd backup.
2.Startup the database in MOUNT mode.
3.recover database until time "2003-03-23-12:00:00"
4.All the archive logs will get applied
5.Open the database with reset logs.I should go back by 3 days wrt to data.

Am I missing anything.
My questions:
Should I restore the control files(of FEb 3) before starting the recovery.? Should i restore redo log files?.I donot want the recent changes to be applied to my database after restoring till 23-MAR-03. Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Basavaraja, Ravindra
  INET: Ravindra.Basavaraja_at_T-Mobile.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Mar 26 2003 - 16:33:37 CST