oralce冷备恢复的问题，着急
oracle数据库版本一致，均为10.2.0，原服务器和目标服务器的操作系统也都是2008 server
我已经将控制文件，临时文件，日志文件，数据文件在数据库停止的状态下拷贝了出来，目录如下：

SQL> select name from v$controlfile;



NAME

-------------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\CONTROL01.CTL

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\CONTROL02.CTL

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\CONTROL03.CTL



SQL> select name from v$tempfile;



NAME

--------------------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\TEMP01.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZLTOOLSTMP.DBF



SQL> select member from v$logfile;



MEMBER

---------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\REDO03.LOG

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\REDO02.LOG

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\REDO01.LOG



SQL> select name from v$datafile;



NAME

-------------------------------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\SYSTEM01.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\UNDOTBS01.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\SYSAUX01.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\USERS01.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZLTOOLSTBS.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9BASEITEM.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9PATIENT.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9EXPENSE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9MEDLST.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9DUEREC.DBF

D:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9CISREC.DBF



NAME

-------------------------------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9EPRLOB.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9EPRDAT.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9CISAUDIT.DBF

D:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9INDEXHIS.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9INDEXCIS.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZLBAK2010.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9BLOODDATA.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9DEVBASE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9DEVREC.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9DEVUSE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9INDEXDEV.DBF



NAME

-------------------------------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9HUMANBASE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9HUMANINFO.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9HUMANWAGE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9IFTBASE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9IFTREC.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9INDEXIFT.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9MTLBASE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9MTLREC.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9INDEXMTL.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9MEDBASE.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9MEDREC.DBF



NAME

-------------------------------------------------------



Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9MEDDAY.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9INDEXMDR.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9OPSDATA.DBF

Z:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9PEISDATA.DBF

D:\TESTORCL\XXXDATABASE\ORADATA\ORCL\ZL9CISREC01.DBF

数据文件有的在Z盘有的在D盘，下边应该怎么办？？？？？？才能将冷备的数据恢复。。。。
我查了很多资料，很多情况下，数据都是在oracle的安装的orada的目录下，不适合我这个情况似乎。
------最佳解决方案--------------------
如果可能，数据文件的路径与原服务器上的相同，修改 spfile，使 control_files 指向拷贝过来的控制文件的所在路径
------其他解决方案--------------------