RE: full recovery

AK

   Since extracting the controlfile from your backup seems to be your major issue, perhaps someone on this list that mastered that issue will reply -- how about it? You could also Google for Oracle-L and RMAN, you might find where they posted it.

   8i? Check Appendix C of Freeman's book. The man thinks of everything.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, October 24, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L

More Info :
OS : HP-UX oracle :8.1.7.4.

Dennis ,
We are using controlfile and not recov catalog. Now Since I am on 8.1.7.4 , no different then you. If I dont have a explicit control file backup then finding SNCF ( snapshot control file ) is another way . Since we have a file system backup which any way takes whole backup of file system , it should have SNCF included in it , BUTTTTT that file system backup runs before rman backup . ( I am not the one who did all this .. just looking at some one els's work ).
Yes, I can restore to same path , so no problem with renaming files in rman restore.

oyaa i do have free(man)'s guide but that's for 9i .

Thanks,
-ak

• Original Message ----- To: <ORACLE-L_at_fatcity.com> Cc: <oramagic_at_hotmail.com> Sent: Friday, October 24, 2003 11:15 AM

> AK - This sounds like a disaster recovery test. Be sure to buy Robert
> Freeman's Oracle9i RMAN Backup & Recovery if you don't have it already. I
am
> on 8.1.6, and had difficulty extracting the control file from the backup
> (others on this list have done it, this is better on 9i). So I just
> "cheated" by backing that up after the RMAN backup and restoring it first.
> That way I can start RMAN and execute a STARTUP MOUNT. You don't say so
> explicitly, but I'm guessing you're using the control file to run RMAN. I
> never figured out how to pull the RMAN backup files from a location other
> than their original path, but fortunately with Unix it is easy to create a
> link. Can you restore the data files to their original path?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> From: AK [mailto:oramagic_at_hotmail.com]
> Sent: Friday, October 24, 2003 1:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: full recovery
>
>
> 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).