Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restore RMAN backup from another location

RE: Restore RMAN backup from another location

From: Stahlke, Mark <mstahlke_at_denvernewspaperagency.com>
Date: Tue, 7 Feb 2006 15:31:35 -0700
Message-ID: <60AF93260A2FC24FB0049527CA68AE7B2CA14C@BEE01.dna.root.ad>


I gather you are doing this in Windows. If so, then the easiest thing to do is map a drive letter to the disk drive that contains the RMAN backup file. Make sure the rest of the directory path matches the original backup file spec.  

For example:
Original backup file was F:\oracle\backup\some_backup_file_name Put backup file in C:\oracle\backup\some_backup_file_name Map the F: drive to the C: drive and life will be good  

The one time I had to do this I had an additional complication. My CDROM drive was using the drive letter (D:) I needed. I had to reconfigure the CDROM to be the F: drive.


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Li-Shan Cheng
Sent: Tuesday, February 07, 2006 3:11 PM To: oracle-l_at_freelists.org
Subject: Restore RMAN backup from another location

Hi  

I was wondering how to restore an Oracle 9i RMAN backup from a location where it was not backed up to.  

For example I backed up the database to F:\, I then take this backup to another Server where there is no F Drive, how do I tell RMAN in the new server he should look in a different location to restore? There is no problems with controlfiles and archive logs since we can specify the location but I cant find a way for normal backup sets.  

There is a way in 9i which is to backup an existing backup set to another location, not really the desired way.
In 10g we can use the catalog command to change the location. Anyone know any other smarter way in 9i?    

Cheers    

LSC  

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 07 2006 - 16:31:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US