求助（急�。。。�

oncb

我用的備份軟件將Oracle數(shù)據(jù)庫(kù)全備份到磁帶，備份服務(wù)器和Oracle服務(wù)器不是同一臺(tái)機(jī)器，然后用備份集恢復(fù)控制文件：\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在執(zhí)行這個(gè)段代碼后報(bào)錯(cuò)，錯(cuò)誤如下：\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幫我分析下原因吧，謝謝

無(wú)牙

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寫錯(cuò)了吧?\r\n應(yīng)該是：\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[ 本帖最后由 無(wú)牙 于 2009-10-9 15:44 編輯 ]