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',
'/u01/app/oracle/oradata/orcl/report_value_space04.dbf',
'/u01