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

           Windows环境下恢复linux环境下的oracle冷备份

1.Linux下冷备份

1.1备份生成控制文件

在弹出的命令行窗口以sysdba身份登陆，要输入:系统用户名/登陆密码@数据库实例名，如sys/oviovi@orcl

执行alter database backup controlfile to trace resetlogs，在/u01/oracle/product/10.1.0/admin

/orcl/udump目录中生成的控制文件中截取

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "ORCL"RESETLOGS  NOARCHIVELOG

    MAXLOGFILES16

   MAXLOGMEMBERS 3

    MAXDATAFILES100

    MAXINSTANCES8

   MAXLOGHISTORY 292

LOGFILE

  GROUP 1'/u01/app/oracle/oradata/orcl/redo01.log' SIZE 50M,

  GROUP 2'/u01/app/oracle/oradata/orcl/redo02.log' SIZE 50M,

  GROUP 3'/u01/app/oracle/oradata/orcl/redo03.log' SIZE 50M

-- STANDBY LOGFILE

DATAFILE

 '/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',