DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype:=dbms_backup_restore.deviceAllocate (type=>'',ident=>'dev');
DBMS_BACKUP_RESTORE.restoreSetDatafile;
dbms_backup_restore.restoreControlfileTo('/usr/app/oracle/oradata/bean/control01.ctl');
dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'/backup/con_c-3174958997-20090713-00', params=>null);
dbms_backup_restore.deviceDeallocate;
END;
更多信息参考:
http://www.eygle.com/archives/2005/06/oorman06026iioe.html
devtype varchar2(256);
done boolean;
BEGIN
devtype:=dbms_backup_restore.deviceAllocate (type=>'',ident=>'dev');
DBMS_BACKUP_RESTORE.restoreSetDatafile;
dbms_backup_restore.restoreControlfileTo('/usr/app/oracle/oradata/bean/control01.ctl');
dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'/backup/con_c-3174958997-20090713-00', params=>null);
dbms_backup_restore.deviceDeallocate;
END;
更多信息参考:
http://www.eygle.com/archives/2005/06/oorman06026iioe.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12878495/viewspace-608991/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12878495/viewspace-608991/