dbms_backup_restore恢复包！

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/