Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving RMAN Disk Backup Files
Moving RMAN Disk Backup FilesI hope this helps.
steve
You should be able to use "junction points" with the util "linkd" It's like soft link for Winduhs..
If you need the drive letter, use "subst"
First use "diskmgmt.msc" to change the CDROM to point to another drive letter like "Z" then you can do something like this to fake it into thinking D:\path exists.
ex.
show what drive letters I have mounted.
c:\> mountvol
Possible values for VolumeName along with current mount points are:
\\?\Volume{4244542a-81d1-11d9-9cbc-806d6172696f}\
C:\
\\?\Volume{86e91c06-8238-11d9-9a36-806d6172696f}\
E:\
\\?\Volume{86e91c07-8238-11d9-9a36-806d6172696f}\
F:\
\\?\Volume{0fb07bb6-82f1-11d9-a80c-806d6172696f}\
M:\
\\?\Volume{0fb07bb7-82f1-11d9-a80c-806d6172696f}\
show the directory I want to create a soft link to.
c:\>dir f:\stuff
Volume in drive F is HOME F:
Volume Serial Number is DC84-AB1C
Directory of f:\stuff
07/13/2005 04:26 PM <DIR> . 07/13/2005 04:26 PM <DIR> .....
create a softlink called my_stuff that point to f:\stuff
c:\>linkd my_stuff f:\stuff
Link created at: my_stuff
verify the link.
c:\>dir my_stuff
Volume in drive C is DSK1_VOL1
Volume Serial Number is 9288-7A80
Directory of c:\my_stuff
...
<stuff>
make the softlink look like the drive letter "K:"
c:\>subst k: c:\my_stuff
Show what's in K:
c:\>dir k:
Volume in drive K is HOME F:
Volume Serial Number is DC84-AB1C
Directory of K:\
07/13/2005 04:26 PM <DIR> . 07/13/2005 04:26 PM <DIR> .....
When you're done, you can undo it with:
subst k: /d
remove the link.
c:\>linkd my_stuff /D
The delete operation succeeded.
Greetings,
This question pertains to Oracle 9.2.0.4 on Winblows.
Is there a way to convince RMAN to use backup files from a location other than where they were created?
I was duplicating a database from an old RMAN backup on a Windows system that has an entirely different disk configuration than the server it normally runs on. The RMAN backups are written to d:\oracle\backups. When I tried to restore the database on the new box, RMAN insisted on looking for the backup files in d:\oracle\backups. Unfortunately, the d: drive on the new machine is a CDROM. Try as I might, I couldn't find a way to make RMAN look somewhere else for the backup files. Eventually I got around the problem by disabling the CDROM and mapping a network drive as d: to the c: drive. This worked but it seems like a Mickey Mouse solution.
Did I miss something easy? Is there a way to tell RMAN where to find the backup files?
Cheers,
Mark Stahlke
Oracle D'ohBA
Denver Newspaper Agency
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 14 2005 - 17:27:45 CDT
![]() |
![]() |