合 Oracle之dbms_backup_restore包的使用
Tags: Oracle备份恢复dbms_backup_restore
该包可以在mount状态下使用。
还原控制文件
1 2 3 4 5 6 7 8 9 10 11 12 13 | --restore Controlfile 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=>'/tmp/2015_04_30/control01.ctl'); sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'/tmp/2015_04_30/o1_mf_annnn_TAG20150430T160239_bn3rdzd7_.bkp', params=>null); sys.dbms_backup_restore.deviceDeallocate; END; / |