测试

最新推荐文章于 2020-10-30 22:16:29 发布

HodyYau

最新推荐文章于 2020-10-30 22:16:29 发布

阅读量511

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/yaohongdi1987/article/details/28327021

版权

oracle 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

run{
set newname for datafile '+DATA/hisdb/datafile/users.259.831648657' to '/oradata/hisdb/datafile/users.259.831648657'
set newname for datafile '+DATA/hisdb/datafile/undotbs1.258.831648657' to '/oradata/hisdb/datafile/undotbs1.258.831648657'
set newname for datafile '+DATA/hisdb/datafile/sysaux.257.831648657' to '/oradata/hisdb/datafile/sysaux.257.831648657'
set newname for datafile '+DATA/hisdb/datafile/system.256.831648657' to '/oradata/hisdb/datafile/system.256.831648657'
set newname for datafile '+DATA/hisdb/datafile/undotbs2.267.831648771' to '/oradata/hisdb/datafile/undotbs2.267.831648771'
set newname for datafile '+DATA/hisdb/datafile/ts_emr.01.dbf' to '/oradata/hisdb/datafile/ts_emr.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr.02.dbf' to '/oradata/hisdb/datafile/ts_emr.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_jk.01.dbf' to '/oradata/hisdb/datafile/ts_emr_jk.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_jk.02.dbf' to '/oradata/hisdb/datafile/ts_emr_jk.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/batj.01.dbf' to '/oradata/hisdb/datafile/batj.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/batj.02.dbf' to '/oradata/hisdb/datafile/batj.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_jyk.01.dbf' to '/oradata/hisdb/datafile/ts_jyk.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_jyk.02.dbf' to '/oradata/hisdb/datafile/ts_jyk.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_his4bc.01.dbf' to '/oradata/hisdb/datafile/ts_his4bc.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_his4bc.02.dbf' to '/oradata/hisdb/datafile/ts_his4bc.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_gy.01.dbf' to '/oradata/hisdb/datafile/ts_emr_gy.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_gy.02.dbf' to '/oradata/hisdb/datafile/ts_emr_gy.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_zy.01.dbf' to '/oradata/hisdb/datafile/ts_emr_zy.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_zy.02.dbf' to '/oradata/hisdb/datafile/ts_emr_zy.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_mz.01.dbf' to '/oradata/hisdb/datafile/ts_emr_mz.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_mz.02.dbf' to '/oradata/hisdb/datafile/ts_emr_mz.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_tjfx.01.dbf'to '/oradata/hisdb/datafile/ts_emr_tjfx.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_emr_tjfx.02.dbf'to '/oradata/hisdb/datafile/ts_emr_tjfx.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_yizhu.01.dbf' to '/oradata/hisdb/datafile/ts_yizhu.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_yizhu.02.dbf' to '/oradata/hisdb/datafile/ts_yizhu.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_batj.01.dbf' to '/oradata/hisdb/datafile/ts_batj.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_batj.02.dbf' to '/oradata/hisdb/datafile/ts_batj.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_his4cs.01.dbf' to '/oradata/hisdb/datafile/ts_his4cs.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_his4cs.02.dbf' to '/oradata/hisdb/datafile/ts_his4cs.02.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_cp3_01.dbf' to '/oradata/hisdb/datafile/ts_cp3_01.dbf'
set newname for datafile '+DATA/hisdb/datafile/bajk.01.dbf' to '/oradata/hisdb/datafile/bajk.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/ts_zongwu.01.dbf' to '/oradata/hisdb/datafile/ts_zongwu.01.dbf'
set newname for datafile '+DATA/hisdb/datafile/xueye.01.dbf' to '/oradata/hisdb/datafile/xueye.01.dbf'
restore database;
switch datafile all;

}

DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype:=sys.dbms_backup_restore.deviceAllocate (type=>'',ident=>'t1');
sys.dbms_backup_restore.restoreSetDatafile;
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>6,toname=>'/oradata/hisdb/datafile/ts_emr.01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>10,toname=>'/oradata/hisdb/datafile/batj.01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>16,toname=>'/oradata/hisdb/datafile/ts_emr_gy.01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>24,toname=>'/oradata/hisdb/datafile/ts_yizhu.01.dbf');
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'/rman/data/Oracle_20140603_Level_1_data_6756.rman', params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/

alter database rename file '+DATA/hisdb/datafile/users.259.831648657' to '/oradata/hisdb/datafile/users.259.831648657' ;
alter database rename file '+DATA/hisdb/datafile/undotbs1.258.831648657' to '/oradata/hisdb/datafile/undotbs1.258.831648657' ;
alter database rename file '+DATA/hisdb/datafile/sysaux.257.831648657' to '/oradata/hisdb/datafile/sysaux.257.831648657' ;
alter database rename file '+DATA/hisdb/datafile/system.256.831648657' to '/oradata/hisdb/datafile/system.256.831648657' ;
alter database rename file '+DATA/hisdb/datafile/undotbs2.267.831648771' to '/oradata/hisdb/datafile/undotbs2.267.831648771' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr.01.dbf' to '/oradata/hisdb/datafile/ts_emr.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr.02.dbf' to '/oradata/hisdb/datafile/ts_emr.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_jk.01.dbf' to '/oradata/hisdb/datafile/ts_emr_jk.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_jk.02.dbf' to '/oradata/hisdb/datafile/ts_emr_jk.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/batj.01.dbf' to '/oradata/hisdb/datafile/batj.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/batj.02.dbf' to '/oradata/hisdb/datafile/batj.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_jyk.01.dbf' to '/oradata/hisdb/datafile/ts_jyk.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_jyk.02.dbf' to '/oradata/hisdb/datafile/ts_jyk.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_his4bc.01.dbf' to '/oradata/hisdb/datafile/ts_his4bc.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_his4bc.02.dbf' to '/oradata/hisdb/datafile/ts_his4bc.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_gy.01.dbf' to '/oradata/hisdb/datafile/ts_emr_gy.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_gy.02.dbf' to '/oradata/hisdb/datafile/ts_emr_gy.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_zy.01.dbf' to '/oradata/hisdb/datafile/ts_emr_zy.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_zy.02.dbf' to '/oradata/hisdb/datafile/ts_emr_zy.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_mz.01.dbf' to '/oradata/hisdb/datafile/ts_emr_mz.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_mz.02.dbf' to '/oradata/hisdb/datafile/ts_emr_mz.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_tjfx.01.dbf'to '/oradata/hisdb/datafile/ts_emr_tjfx.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_emr_tjfx.02.dbf'to '/oradata/hisdb/datafile/ts_emr_tjfx.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_yizhu.01.dbf' to '/oradata/hisdb/datafile/ts_yizhu.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_yizhu.02.dbf' to '/oradata/hisdb/datafile/ts_yizhu.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_batj.01.dbf' to '/oradata/hisdb/datafile/ts_batj.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_batj.02.dbf' to '/oradata/hisdb/datafile/ts_batj.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_his4cs.01.dbf' to '/oradata/hisdb/datafile/ts_his4cs.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_his4cs.02.dbf' to '/oradata/hisdb/datafile/ts_his4cs.02.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_cp3_01.dbf' to '/oradata/hisdb/datafile/ts_cp3_01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/bajk.01.dbf' to '/oradata/hisdb/datafile/bajk.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/ts_zongwu.01.dbf' to '/oradata/hisdb/datafile/ts_zongwu.01.dbf' ;
alter database rename file '+DATA/hisdb/datafile/xueye.01.dbf' to '/oradata/hisdb/datafile/xueye.01.dbf' ;