RE: Restore RMAN backup from another location

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <exriscer@xxxxxxxxx>
  • Date: Wed, 8 Feb 2006 08:04:13 -0500



Look in the Rman documentation.  Specifically, look at the SET NEWNAME
FOR DATAFILE command.  It's got everything you are looking for.




From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Li-Shan Cheng
Sent: Wednesday, February 08, 2006 12:58 AM
To: mstahlke@xxxxxxxxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Restore RMAN backup from another location


Yea I was doing it with Windows and I did end up mapping the drives. I
asked the guys to partition the disk or even add more disks so I can get
E and F drive, they didnt do it, I had to partition myself and I found
out no free disk space to get a F drive! 


However I thought there must be some way in RMAN to do this.... :-S







On 2/7/06, Stahlke, Mark <mstahlke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote: 

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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]
On Behalf Of Li-Shan Cheng
Sent: Tuesday, February 07, 2006 3:11 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Restore RMAN backup from another location




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?









Other related posts: