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: Moving RMAN Disk Backup Files

Re: Moving RMAN Disk Backup Files

From: Steve Perry <sperry_at_sprynet.com>
Date: Thu, 14 Jul 2005 17:25:36 -0500
Message-ID: <049201c588c2$f5ba7e00$6800a8c0@desk1>


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>          ..
...
<stuff>

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>          ..
...
<more stuff>

remove the drive:

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-l
Received on Thu Jul 14 2005 - 17:27:45 CDT

Original text of this message

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