RMAN ORA-19693錯誤解決

10.2.0.5 on windows 64 bit
 
現象：從一個 server A拷貝backupset 至另一個server B。在server B上恢複。首先使用‘catalog start with ’編錄backupset .
 
在恢複資料庫的時候出現：
 
RMAN> restore database force;

Starting restore at 31-MAY-14
 using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
 channel ORA_DISK_1: specifying datafile(s) to restore from backup set
 restoring datafile 00001 to E:\ORADATA\TESTDGP\SYSTEM01.DBF
 restoring datafile 00002 to E:\ORADATA\TESTDGP\UNDOTBS01.DBF
 restoring datafile 00003 to E:\ORADATA\TESTDGP\SYSAUX01.DBF
 restoring datafile 00004 to E:\ORADATA\TESTDGP\USERS01.DBF
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03002: failure of restore command at 05/31/2014 10:12:51
 ORA-19693: backup piece E:\BAK_04P9JK4Q_1_11 already included

在mos上找到如下文章：ID 288129.1提到恢複的時候backupset只能有一個copy

使用list backup summary:
 
RMAN> list backup summary;

List of Backups
 ===============
 Key    TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
 ------- -- -- - ----------- --------------- ------- ------- ---------- ---
 4      B  F  A DISK        30-MAY-14      1      3      NO        TAG201405
 30T170010
 5      B  F  A DISK        30-MAY-14      1      3      NO        TAG201405
 30T170010

使用RMAN> list backup of database tag=TAG20140530T170010;列出copies大於1的。

將磁碟的backupset重新命名並刪除多餘的backup 再重新catalog即可。
 
兩種情況：
 
1 實際backupset只有一份，由於多次catalog造成entries重複。
 
可以將backupset重新命名，重新catalog再crosscheck
 
備忘：這裡應該可以用其他方式刪除entry??
 
2 實際backupset就有多分，刪除多餘backupset再crosscheck

OERR: ORA-19693 backup piece %s already included (文檔 ID 288129.1)

APPLIES TO:
 Oracle Server - Enterprise Edition - Version 10.1.0.2 and later
 Information in this document applies to any platform.
 Checked for relevance on 12 Jul 2012
PURPOSE
 
Provide OERR information for ORA-19693
 
DETAILS
 
{ This note contains error information about an "Oracle Server" error number. It may contain additional support notes as described in Note:22080.1 }
 
Error:      ORA-19693
 Text:      backup piece %s already included
 ---------------------------------------------------------------------------
 Cause: This backup piece was already specified for inclusion in the restore conversation. A restore conversation may process only a single instance of a backup piece.
 Action: Remove the specified duplicate backup piece in restore steps and restart the conversation.

--------------------------------------推薦閱讀 --------------------------------------

RMAN 配置歸檔日誌刪除策略

Oracle基礎教程之通過RMAN複製資料庫

RMAN備份策略制定參考內容

RMAN備份學習筆記

OracleDatabase Backup加密 RMAN加密

--------------------------------------分割線 --------------------------------------