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_1channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile（s） to restore from backup set
restoring datafile 00001 to E:ORADATATESTDGPSYSTEM01.DBF
restoring datafile 00002 to E:ORADATATESTDGPUNDOTBS01.DBF
restoring datafile 00003 to E:ORADATATESTDGPSYSAUX01.DBF
restoring datafile 00004 to E:ORADATATESTDGPUSERS01.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再crosscheckOERR: 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 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址