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 指向拷贝过来的控制文件的所在路径
------其他解决方案--------------------