求助（急！�。。�

oncb

我用的備份軟件將Oracle數(shù)據(jù)庫全備份到磁帶，備份服務(wù)器和Oracle服務(wù)器不是同一臺機(jī)器，然后用備份集恢復(fù)控制文件：
DECLARE
devtype VARCHAR2(256);
BEGIN
devtype:=SYS.DBMS_BACKUP_RESTORE.DeviceAllocate(type=>'sbt_tape',ident=>'t1');
SYS.DBMS_BACKUP_RESTORE.restoreSetDatafile;
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL');
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL');
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL');
SYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918', params=>null);
SYS.DBMS_BACKUP_RESTORE.DeviceDeAllocate;
END;
在執(zhí)行這個段代碼后報錯，錯誤如下：
SYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>'Q-3A45E1ACA9664:#
586:hj:37_699791949:RMAN FULL DB ORCL_1255055918', params=>null);
                                                 *
ERROR at line 9:
ORA-06550: line 9, column 50:
PLS-00201: identifier 'DONE' must be declared
ORA-06550: line 9, column 1:
PL/SQL: Statement ignored


幫我分析下原因吧，謝謝

無牙

SYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918', params=>null);

寫錯了吧?
應(yīng)該是：
declare
     devtype varchar2(256);
     done boolean;

BEGIN
devtype:=SYS.DBMS_BACKUP_RESTORE.DeviceAllocate(type=>'sbt_tape',ident=>'t1');
SYS.DBMS_BACKUP_RESTORE.restoreSetDatafile;
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL');
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL');
SYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>'E:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL');
SYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918', params=>null);
SYS.DBMS_BACKUP_RESTORE.DeviceDeAllocate;
END;

[ 本帖最后由 無牙 于 2009-10-9 15:44 編輯 ]