2. Tell damagement to go away and you'll call them when its done.
3. Get out Robert Freeman's book on RMAN, you do have that right and its all worn out from being dogeared and spilling beer on it, RIGHT?
4. restore the controlfile manually from the backup, you may have to figure out the piece name based on your tape management logs/repository.
5. once the controlfile is restored, mount, and restore the rest of the database. Restoring a controlfile without a repository is the hardest thing you'll ever have to do with RMAN, been there done that in a production environment when darn near everything was lost.
Joe
AK wrote:
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: Joe Testa INET: [EMAIL PROTECTED]
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: [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).
