Oracle11gRMAN异机恢复（LinuxtoWindows）

Oracle 11g RMAN 异机恢复（Linux to Windows）

原库确定数据文件，日志文件，tempfile 文件信息

select group#,status,type, member from v$logfile;
col name format a65
select file#,name,bytes/1024/1024 MB from v$datafile;
select name from v$controlfile;

推荐阅读：

RMAN 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

1.创建实例
oradim （命令行下包含多种可选项，可自行选择）
oradim -new -sid maxld
在已有数据库运行的情况下需要注意设置环境变量
c:\set oracle_sid=demo
c:\sqlplus / as sysdba

2.创建或修改初始化参数文件
手头有其他数据库的情况下
sql>create pfile from spfile
此文件在dbhome_1下的database中
根据实际情况修改pfile文件
替换SID等
例如
orcl.__db_cache_size=205520896 替换为 demo.__db_cache_size=205520896

3.创建相应的目录结构
*.audit_file_dest=&＃39;C:\app\Administrator\admin\demo\adump&＃39;
*.control_files=&＃39;C:\app\Administrator\oradata\demo\control01.ctl&＃39;,
&＃39;C:\app\Administrator\flash_recovery_area\demo\control02.ctl&＃39;

4.启动实例
sql>startup nomount

5.拷贝修改pfile，准备控制文件。
cp /oracle10/oradata/ora10/control01.ctl .
SQL> startup mount pfile=&＃39;/tmp/pfile10.ora&＃39;;
ORACLE instance started.

6. 恢复数据库。

run {
ALLOCATE CHANNEL ch0 TYPE disk;
set newname for datafile 1 to &＃39;C:\app\Administrator\oradata\system01.dbf&＃39;;
set newname for datafile 2 to &＃39;C:\app\Administrator\oradata\sysaux01.dbf&＃39;;
set newname for datafile 3 to &＃39;C:\app\Administrator\oradata\undotbs01.dbf&＃39;;
set newname for datafile 4 to &＃39;C:\app\Administrator\oradata\users01.dbf&＃39;;
set newname for datafile 5 to &＃39;C:\app\Administrator\oradata\MAXIMO_DATA.dbf&＃39;;
set newname for datafile 6 to &＃39;C:\app\Administrator\oradata\MAXIMO_index.dbf&＃39;;
set newname for datafile 7 to &＃39;C:\app\Administrator\oradata\MAXIMO_DATA02.dbf&＃39;;
set newname for datafile 8 to &＃39;C:\app\Administrator\oradata\MAXIMO_index02.dbf&＃39;;

set newname for tempfile 1 to &＃39;C:\app\Administrator\oradata\temp01.dbf&＃39;;
set newname for tempfile 2 to &＃39;C:\app\Administrator\oradata\MAXIMO_temp.dbf&＃39;;
restore database;
switch datafile all;
switch tempfile all;
release channel ch0;

}

recover database;

处理redolog

处理tempfile