Re: full recovery

1. Get a beer.
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: 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).