遭遇BUG 4483368出現ORA-19693錯誤後的處理辦法

客戶資料庫透過手工指令碼實現DATAGUARD，即透過將生產庫歸檔日誌定時備份、恢復到備庫的方式實現。然而今天卻出現了恢復不成功的問題：[@more@]

錯誤資訊：

RMAN-00571: ====================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS ======
RMAN-00571: ====================================
RMAN-03002: failure of recover command at 05/23/2008 09:38:48
ORA-19693: backup piece /opt/oracle/admin/mnt_new/HERMES_NEW/2008-05-23.00-00-01/jrjh24rf_1_1 already included
透過list backupset of archivelog all;命令發現控制檔案中對backuppiece /opt/oracle/admin/mnt_new/HERMES_NEW/2008-05-23.00-00-01/jrjh24rf_1_1有兩條記錄，於是試圖去uncatalog，結果出錯：

RMAN> change backuppiece '/opt/oracle/admin/mnt_new/HERMES_NEW/2008-05-23.00-00-01/jrjh24rf_1_1' uncatalog;

RMAN-00571: ====================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS ======
RMAN-00571: ====================================
RMAN-03002: failure of uncatalog command at 05/23/2008 10:00:30
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece

怎麼辦呢？於是將backuppiece移到別的地方，執行crosscheck backupset of archivelog all;和delete expired backupset of archivelog all;然後將backuppiece移回來並執行catalog backuppiece '/opt/oracle/admin/mnt_new/HERMES_NEW/2008-05-23.00-00-01/jrjh24rf_1_1';最後執行恢復，一切OK。

為什麼控制檔案包含兩條該backuppiece的記錄呢？這是因為觸發了BUG 4483368。該BUG可能在ASM上的DATABASE上使用catalog start 命令時觸發：SEVERAL RMAN CATALOG START WITH CREATES DUPLICATE CATALOG ENTRIES