求助（急！！！）

oncb

我用的备份软件将Oracle数据库全备份到磁带，备份服务器和Oracle服务器不是同一台机器，然后用备份集恢复控制文件：
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;
在执行这个段代码后报错，错误如下：
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);

写错了吧?
应该是：
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 编辑 ]