linux下oracle数据冷备份在windows下恢复

Windows环境下恢复linux环境下的oracle冷备份1.Linux下冷备份1.1备份生成控制文件在弹出的命令行窗口以sysdba身份登陆，要输入:系统用户名/登陆密码@数据库实例名，如sys/oviovi@orcl执行alterdatabasebackupcontrolfiletotraceresetlogs，在/u01/oracle/product/10.1.0/admin/orcl/udump目录中生成的控制文件中截取STARTUPNOMOUNTCREATECONTROLFILEREUSEDATABASEORCLRESETLOGSNOARCHIVELOGMAXLOGFILES16MAXLOGMEMBERS3MAXDATAFILES100MAXINSTANCES8MAXLOGHISTORY292LOGFILEGROUP1'/u01/app/oracle/oradata/orcl/redo01.log'SIZE50M,GROUP2'/u01/app/oracle/oradata/orcl/redo02.log'SIZE50M,GROUP3'/u01/app/oracle/oradata/orcl/redo03.log'SIZE50M--STANDBYLOGFILEDATAFILE'/u01/app/oracle/oradata/orcl/system01.dbf','/u01/app/oracle/oradata/orcl/undotbs01.dbf','/u01/app/oracle/oradata/orcl/sysaux01.dbf','/u01/app/oracle/oradata/orcl/users01.dbf','/u01/app/oracle/oradata/orcl/suncs_space.dbf','/u01/app/oracle/oradata/orcl/hbzbtj_space.dbf','/u01/app/oracle/oradata/orcl/SG_ODS_space.dbf','/u01/app/oracle/oradata/orcl/gesp_space.dbf','/u01/app/oracle/oradata/orcl/test_space01.dbf','/u01/app/oracle/oradata/orcl/test_space02.dbf','/u01/app/oracle/oradata/orcl/test_space03.dbf','/u01/app/oracle/oradata/orcl/report_value_space01.dbf','/u01/app/oracle/oradata/orcl/report_value_space02.dbf','/u01/app/oracle/oradata/orcl/report_value_space03.dbf','/u01/app/oracle/oradata/orcl/report_value_space04.dbf','/u01/app/oracle/oradata/orcl/report_value_space05.dbf','/u01/app/oracle/oradata/orcl/report_value_space06.dbf','/u01/app/oracle/oradata/orcl/report_value_space07.dbf','/u01/app/oracle/oradata/orcl/report_value_space08.dbf','/u01/app/oracle/oradata/orcl/report_value_space09.dbf','/u01/app/oracle/oradata/orcl/report_value_space10.dbf','/u01/app/oracle/oradata/orcl/report_value_space11.dbf','/u01/app/oracle/oradata/orcl/report_value_space12.dbf','/u01/app/oracle/oradata/orcl/report_value_space13.dbf','/u01/app/oracle/oradata/orcl/report_value_space14.dbf','/u01/app/oracle/oradata/orcl/report_value_space15.dbf','/u01/app/oracle/oradata/orcl/report_value_space16.dbf','/u01/app/oracle/oradata/orcl/report_value_space17.dbf','/u01/app/oracle/oradata/orcl/report_value_space18.dbf','/u01/app/oracle/oradata/orcl/report_value_space19.dbf','/u01/app/oracle/oradata/orcl/report_value_space20.dbf','/u01/app/oracle/oradata/orcl/report_value_space21.dbf','/u01/app/oracle/oradata/orcl/report_value_space22.dbf','/u01/app/oracle/oradata/orcl/report_value_space23.dbf','/u01/app/oracle/oradata/orcl/report_value_space24.dbf','/u01/app/oracle/oradata/orcl/report_value_space25.dbf','/u01/app/oracle/oradata/orcl/report_value_space26.dbf','/u01/app/oracle/oradata/orcl/report_value_space27.dbf','/u01/app/oracle/oradata/orcl/report_value_space28.dbf','/u01/app/oracle/oradata/orcl/report_value_space29.dbf','/u01/app/oracle/oradata/orcl/report_value_space30.dbf','/u01/app/oracle/oradata/orcl/report_value_space31.dbf'CHARACTERSETZHS32GB18030;1.2停止数据库实例命令窗口：shutdownimmediate停止数据库实例；1.3关键文件备份备份生成的控制文件中涉及的.LOG和.dbf文件；2.Windows下恢复2.1数据库版本新Windows设备上安装的oracle数据库版本必须与linux环境上的版本一致或者高于此版本；2.2数据库实例创建的数据库实例最好与linux环境下保持一致；本次恢复命名为：orcl；2.3停止数据库实例同linux环境，shutdownimmediate将linux下备份的文件拷贝至Windows下对应的目录下（linux路径：u01/app/oracle/oradata/orcl替换到F:\oracle\product\10.2.0\oradata\orcl）；2.4调整文件路径由于linux环境和Windows环境下数据库实例的安装目录不同，必须将控制文件中的编码和数据库实例的路径调整为新环境下。在sqlplus命令窗口中以sys用户登录来执行该控制文件(linux路径：u01/app/oracle/oradata/orcl替换为F:\oracle\product\10.2.0\oradata\orcl)，并保存为control.sql脚本；--STARTUPNOMOUNTCREATECONTROLFILEREUSEDATABASEORCLRESETLOGSNOARCHIVELOGMAXLOGFILES16MAXLOGMEMBERS3MAXDATAFILES100MAXINSTANCES8MAXLOGHISTORY292LOGFILEGROUP1'F:\oracle\product\10.2.0\oradata\orcl\redo01.log'SIZE50M,GROUP2'F:\oracle\product\10.2.0\oradata\orcl\redo02.log'SIZE50M,GROUP3'F:\oracle\product\10.2.0\oradata\orcl\redo03.log'SIZE50M--STANDBYLOGFILEDATAFILE'F:\oracle\product\10.2.0\oradata\orcl\system01.dbf','F:\oracle\product\10.2.0\oradata\orcl\undotbs01.dbf','F:\oracle\product\10.2.0\oradata\orcl\sysaux01.dbf','F:\oracle\product\10.2.0\oradata\orcl\users01.dbf','F:\oracle\product\10.2.0\oradata\orcl\suncs_space.dbf','F:\oracle\product\10.2.0\oradata\orcl\hbzbtj_space.dbf','F:\oracle\product\10.2.0\oradata\orcl\SG_ODS_space.dbf','F:\oracle\product\10.2.0\oradata\orcl\gesp_space.dbf','F:\oracle\product\10.2.0\oradata\orcl\test_space01.dbf','F:\oracle\product\10.2.0\oradata\orcl\test_space02.dbf','F:\oracle\product\10.2.0\oradata\orcl\test_space03.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space01.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space02.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space03.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space04.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space05.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space06.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space07.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space08.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space09.dbf','F:\oracle\product\10.2.0\oradata\orcl\report_value_space10.dbf','F:\oracle\product\10.2.0\orada