如何使用 RMAN 异机恢复部分表空间

-------在还原好控制文件后，将实例启动到mount状态，然后开始还原部分表空间数据文件：

rman target / nocatalog msglog=/home/oracledb/rman.log <run {? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';? ? ? ? ? ? ?
send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=http://blog.csdn.net/lixora';

set newname for datafile? 1 to '/oracle11/oradata/datafile/system.262.762381347' ;
set newname for datafile? 3 to '/oracle11/oradata/datafile/undotbs1.264.762381401';
set newname for datafile? 4 to '/oracle11/oradata/datafile/undotbs2.266.762381455';
set newname for datafile 227 to '/oracle11/oradata/datafile/system02.dbf';? ? ? ?
set newname for datafile 344 to '/oracle11/oradata/datafile/lixora.375.820259689';
set newname for datafile 345 to '/oracle11/oradata/datafile/lixora.414.820949317';

?restore tablespace system,undotbs1,undotbs2，lixora? ;
?switch datafile all;
?
release channel t1;
release channel t2;
}
EOF

---------【如果表空比较多，可以先批量生成表空间的 offline drop 命令】开始恢复数据库

recover database skip forever tablespace SYSAUX,TEMP,USERS,INDEX_DATA;

release channel ch0;
release channel ch1;
}
EOF

?

---以resetlogs 方式打开oracle数据库
alter database open resetlogs；

--------------------------------------推荐阅读 --------------------------------------

--------------------------------------分割线 --------------------------------------