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.restoreControlfileTo (cfname=>'D:\oracle\oradata\ora9\control04.ctl');
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'D:\oracle\backup\FULL_ORA9_05KFDIM1', params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
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=>01,toname=>'/cdata/sxuccms/system01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>02,toname=>'/cdata/sxuccms/undotbs01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>03,toname=>'/cdata/sxuccms/sysaux01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>06,toname=>'/cdata/sxuccms/sysaux02.dbf');
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'/bak/rman/DataFile_SXUCCMS_682745422_20090329.198',
params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7597006/viewspace-600400/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7597006/viewspace-600400/