full recovery

From: AK <oramagic_at_hotmail.com>
Date: Fri, 24 Oct 2003 10:14:30 -0800
Message-ID: <F001.005D43AC.20031024101430@fatcity.com>

Here is a scenerio :
I am taking full database backup everynight using rman to tape . which includes archive logs and control file. Not using catalog.Also have a backup of complete file system including oracle software and configuration files ( init.ora , listener.ora etc.. ) I lost the host on a particular day at 12 am afternoon. Now I want to restore this db to latest possible time to another host ( with same name ) . what are steps I need to do .

1. restore oracle software from tape.
2. restore config files ( init.ora , listener. ora ).
3. startup instance with nomount.
4. ( .... here I get confused , since I dont have latest control file , what are implication , and what should I do )
5. connect to rman
6. run ( set until ...; restore db ; recover db ; )

Thanks,
-ak

--

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

Author: AK
  INET: oramagic_at_hotmail.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 Fri Oct 24 2003 - 13:14:30 CDT