Database Software

hi,

How do I tell RMAN restore to access a backup set taken from production server (D:\) on a backup server that does not have a D:\ drive and has no access to the production server ?

Environment is Windows. The backup set was done on the production server on the D:\ drive. I copied the backup set to the C:\ drive of the backup server(Backup server only has a C:\ drive). I was able to properly restore the control file and startup mount successfully on the backup server. Then I tried mapping a network drive on the backup server as "D:\" back to the C:\ drive itself(so it looks like it has a D:\ drive but it's actually the C:\ drive). I used "set newname" to change new datafile location to C:\ and "alter database rename" to change the new log file location to C:\. But during the restore, RMAN still has trouble accessing the backup set from the virtual network drive "D:\" on the backup server. I also tried using "subst" but it seems that RMAN only looks at the original drive letter, not the virtual drive letter.

The following is the restore portion of the script :
run
{
set newname for datafile 1 to 'C:\ORACLE\.......\SYSTEM01.DBF';
......
set newname for datafile 10 to 'C:\ORACLE\.......\REP01.DBF';
sql "alter database rename file ''D:\ORACLE\.....\REDO01.LOG''
to ''C:\ORACLE\......\REDO01.LOG'' ";
sql "alter database rename file ''D:\ORACLE\.....\REDO02.LOG''
to ''C:\ORACLE\......\REDO02.LOG'' ";
restore database;
switch datafile all;
}
exit

This is the result :

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\....\SYSTEM01.DBF
......
restoring datafile 00010 to C:\ORACLE\....\REP01.DBF
ORA-19624: operation failed, retry possible
ORA-19505: failed to identify file "D:\ORACLE\.....\BK_SCOTTDBSID_2_573438471"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup


When I issued "list backup", I can see all the backup set files are pointed to D:\

The scenario mandates that the backup server only has C:\ and has no access to a D:\ drive or the production server.
Anyway around this problem ?

Thanks