DBMS_BACKUP_RESTORE oracle从磁带上备份集中恢复数据文件 ----------------------------
declare
     devtype varchar2(256);
     done boolean;

BEGIN
devtype:=SYS.DBMS_BACKUP_RESTORE.DeviceAllocate(type=>'sbt_tape',ident=>'t1');
SYS.DBMS_BACKUP_RESTORE.restoreSetDatafile;
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL');
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL');
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL');
SYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918', params=>null);
SYS.DBMS_BACKUP_RESTORE.DeviceDeAllocate;
END;
---------数据恢复 oracle数据库恢复专家 13352468096 QQ:9417901 网站：http://www.sosdb.com-----