RMAN>backup database format 'F:\backup\db_%d_%T_%s' plus archivelog format 'F:\
backup\arch_%d_%T_%s' delete all
input;
run{
SET NEWNAME FOR DATAFILE 1 TO
'F:\oradata\system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO
'F:\ORADATA\UNDOTBS01.DBF';
SET NEWNAME FOR DATAFILE 3 TO
'F:\ORADATA\SYSAUX01.DBF';
SET NEWNAME FOR DATAFILE 4 TO
'F:\ORADATA\USERS01.DBF';
SET NEWNAME FOR DATAFILE 5 TO
'F:\ORADATA\TEST01.DBF';
SET NEWNAME FOR DATAFILE 6 TO
'F:\ORADATA\TBS_TEST01.DBF';
SET NEWNAME FOR DATAFILE 7 TO
'F:\ORADATA\TEST_UNIFORM01.DBF';
SET NEWNAME FOR DATAFILE 8 TO
'F:\ORADATA\USERS02.DBF';
set newname for datafile 9 to
'F:\ORADATA\TB01.DBF';
set newname for datafile 10 to
'F:\ORADATA\MY_UNDO01.DBF';
set newname for datafile 11 to 'F:\ORADATA\TB101.DBF';
set newname for datafile 12 to
'F:\ORADATA\TBS_TEST02.DBF';
set newname for datafile 13 to
'F:\ORADATA\TESTING.DBF';
restore database;
switch datafile all;
}
二、异机恢复数据库
1)创建实例
oradim -new -sid eamcs
2)连接
set ORACLE_SID=eamcs
rman target /
set dbid=1380721776
startup nomount
3)还原参数文件
修改参数文件中的background_dump_dest、audit_file_des、core_dump_des、user_dump_dest路径
创建spfile再启动到nomount
create spfile from pfile;
修改控制文件还原的路径
4)还原控制文件
restore controlfile from 'e:\c-1380721776-20150411-01';
alter dabase mount;
5)还原数据文件
注册备份集
catalog start with 'e:\db_orcl_20150411-83';
还原数据文件
6)恢复数据库
recover database using backup controlfile until cancel;
7)打开数据库
alter database open resetlogs;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26937943/viewspace-1579656/ ，如需转载，请注明出处，否则将追究法律责任。
