oracle版本 11.2.0.3
操作系统 windows server

一、主要步骤 
1、rman备份数据库
2、拷贝rman备份到目的服务器
3、为目标数据库创建项目目录
4、为目标数据库创建pfile或spfile(使用RMAN还原或复制原pfile到目的服务器)
5、还原控制文件
6、还原数据文件
7、OPEN 数据库
1. 拷贝源机器的rman目录到目标系统下
目标环境：
mount下修改
CONFIGURE  CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/rmanbak/%F';
2.恢复spfile
nomount下
RMAN> restore spfile to '/data/oracle/product/10.2.0/spfilenetreporcl.ora' from '/data/rmanbak/c-820432386-20130408-00';
Starting restore at 08-APR-13
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /data/rmanbak/c-820432386-20130408-00
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 08-APR-13
删除dbs原有的spfile文件，把恢复好的spfile拷贝到dbs目录下
cp '/data/oracle/product/10.2.0/spfilenetreporcl.ora' '/data/oracle/product/10.2.0/dbs/spfilenetreporcl.ora';

重新 nomount
恢复 控制文件
3.恢复控制文件
nomount下
RMAN> restore controlfile from '/data/rmanbak/c-820432386-20130408-00';
............
............
4.恢复database
SQL> alter database mount;
Database altered.
RMAN> restore database; 
Starting restore at 08-APR-13
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=320 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
............
............
Finished restore at 08-APR-13


RMAN> recover database; 
............
............
RMAN-06054: media recovery requesting unknown log: thread 1 seq 139 lowscn 7804753
RMAN> recover database until sequence 139 thread 1;
Starting recover at 08-APR-13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 08-APR-13
不完全恢复--
RMAN>alter database open resetlogs