Get a beer.
Tell damagement to go away and you'll call them when its done.
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?
restore the controlfile manually from the backup, you may have to
figure out the piece name based on your tape management logs/repository.
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.


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; )

Please see the official ORACLE-L FAQ: http://www.orafaq.net
Author: Joe Testa
INET: oracle-l_at_oracle-dba.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).

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 7 | next ›
Discussion Overview
grouporacle-l @
postedOct 24, '03 at 6:14p
activeOct 24, '03 at 11:19p



site design / logo © 2021 Grokbase