求助（急！！！）

oncb

我用的备份软件将Oracle数据库全备份到磁带，备份服务器和Oracle服务器不是同一台机器，然后用备份集恢复控制文件：\r\nDECLARE\r\ndevtype VARCHAR2(256);\r\nBEGIN\r\ndevtype:=SYS.DBMS_BACKUP_RESTORE.DeviceAllocate(type=>\'sbt_tape\',ident=>\'t1\'); \r\nSYS.DBMS_BACKUP_RESTORE.restoreSetDatafile;\r\nSYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>\'E:\\oracle\\product\\10.1.0\\oradata\\orcl\\CONTROL01.CTL\');\r\nSYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>\'E:\\oracle\\product\\10.1.0\\oradata\\orcl\\CONTROL02.CTL\');\r\nSYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>\'E:\\oracle\\product\\10.1.0\\oradata\\orcl\\CONTROL03.CTL\');\r\nSYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>\'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918\', params=>null);\r\nSYS.DBMS_BACKUP_RESTORE.DeviceDeAllocate;\r\nEND;\r\n在执行这个段代码后报错，错误如下：\r\nSYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>\'Q-3A45E1ACA9664:#\r\n586:hj:37_699791949:RMAN FULL DB ORCL_1255055918\', params=>null);\r\n                                                 *\r\nERROR at line 9:\r\nORA-06550: line 9, column 50:\r\nPLS-00201: identifier \'DONE\' must be declared\r\nORA-06550: line 9, column 1:\r\nPL/SQL: Statement ignored\r\n\r\n\r\n帮我分析下原因吧，谢谢

无牙

SYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>\'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918\', params=>null);\r\n\r\n写错了吧?\r\n应该是：\r\ndeclare \r\n     devtype varchar2(256);\r\n     done boolean;\r\n\r\nBEGIN\r\ndevtype:=SYS.DBMS_BACKUP_RESTORE.DeviceAllocate(type=>\'sbt_tape\',ident=>\'t1\'); \r\nSYS.DBMS_BACKUP_RESTORE.restoreSetDatafile;\r\nSYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>\'E:\\oracle\\product\\10.1.0\\oradata\\orcl\\CONTROL01.CTL\');\r\nSYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>\'E:\\oracle\\product\\10.1.0\\oradata\\orcl\\CONTROL02.CTL\');\r\nSYS.DBMS_BACKUP_RESTORE.RestoreControlFileTo(cfname=>\'E:\\oracle\\product\\10.1.0\\oradata\\orcl\\CONTROL03.CTL\');\r\nSYS.DBMS_BACKUP_RESTORE.restoreBackupPiece(done=>done,handle=>\'Q-3A45E1ACA9664:#586:hj:37_699791949:RMAN FULL DB ORCL_1255055918\', params=>null);\r\nSYS.DBMS_BACKUP_RESTORE.DeviceDeAllocate;\r\nEND;\n\n[ 本帖最后由 无牙 于 2009-10-9 15:44 编辑 ]