ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dbms_backup_restore恢复包!

dbms_backup_restore恢复包!

原创 Linux操作系统 作者:Tom_webex 时间:2009-05-19 10:52:33 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-09

  • 博文量
    8
  • 访问量
    10704