爱站程序员基地[code]产品DBA工程师在做备份恢复时，在restore database时报错ORA-19693: backup piece %s already included，分析原因为有重复tag备份集存在1.rman备份恢复时ora报错RMAN> restore database;启动 restore 于 13-11月-11使用通道 ORA_DISK_1通道 ORA_DISK_1: 正在开始还原数据文件备份集通道 ORA_DISK_1: 正在指定从备份集还原的数据文件通道 ORA_DISK_1: 将数据文件 00001 还原到 E:\\ORACLE\\ORADATA\\XFF\\SYSTEM01.DBF通道 ORA_DISK_1: 将数据文件 00002 还原到 E:\\ORACLE\\ORADATA\\XFF\\SYSAUX01.DBF通道 ORA_DISK_1: 将数据文件 00003 还原到 E:\\ORACLE\\ORADATA\\XFF\\UNDOTBS01.DBF通道 ORA_DISK_1: 将数据文件 00004 还原到 E:\\ORACLE\\ORADATA\\XFF\\USERS01.DBF通道 ORA_DISK_1: 将数据文件 00005 还原到 E:\\ORACLE\\ORADATA\\XFF\\EXAMPLE01.DBF通道 ORA_DISK_1: 将数据文件 00006 还原到 E:\\ORACLE\\ORADATA\\XFF\\O_ORACLE.DBF通道 ORA_DISK_1: 将数据文件 00007 还原到 E:\\ORACLE\\ORADATA\\XFF\\XIFENFEI01.DBF通道 ORA_DISK_1: 将数据文件 00008 还原到 E:\\ORACLE\\ORADATA\\XFF\\P_TEST01.DBF通道 ORA_DISK_1: 将数据文件 00009 还原到 E:\\ORACLE\\ORADATA\\XFF\\SYS_MG01.DBF通道 ORA_DISK_1: 将数据文件 00010 还原到 E:\\ORACLE\\ORADATA\\XFF\\P101.DBF通道 ORA_DISK_1: 将数据文件 00011 还原到 E:\\ORACLE\\ORADATA\\XFF\\P201.DBF通道 ORA_DISK_1: 将数据文件 00012 还原到 E:\\ORACLE\\ORADATA\\XFF\\P301.DBF通道 ORA_DISK_1: 将数据文件 00015 还原到 E:\\ORACLE\\ORADATA\\XFF\\OGG01.DBF通道 ORA_DISK_1: 将数据文件 00016 还原到 E:\\ORACLE\\ORADATA\\XFF\\SPOT01.DBFRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: restore 命令 (在 11/13/2011 18:19:31 上) 失败ORA-19693: 已包括备份片段 F:\\RMANBACKUP\\9_12_0GMMD2KI_1_1RMAN> list backup summary;备份列表===============关键字 TY LV S 设备类型 完成时间 段数 副本数 压缩标记------- -- -- - ----------- ---------- ------- ------- ---------- ---6 B F A DISK 12-9月 -11 1 2 NO TAG20110912T2154257 B F A DISK 12-9月 -11 1 1 NO TAG20110912T2154258 B F A DISK 12-9月 -11 1 1 NO TAG20110912T22012019693, 00000, \"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.2.Oracle案例分析步骤1、查找出副本数大于1的备份集2、重命名对应的备份集3、使用crosscheck backup检测出无效的备份集4、使用delete noprompt expired backup删除无效备份集5、使用CATALOG START WITH重新添加刚刚重命名的备份集3.结合mos诊断ora错误Bug 4483368: SEVERAL RMAN CATALOG START WITH CREATES DUPLICATE CATALOG ENTRIESAfter several \"RMAN catalog start with \"we have several copies of the same backuppiecein our catalog which we can see with \"list backup;\" and also \"list backup summary;\".However, when I now try to restore with that controlfile instead of a catalogI receive ORA-19693 backup piece \"/opt/oracle/admin/mnt/HERMES2/bkp/...\"is already included.--------------------------------------ORACLE-DBA----------------------------------------最权威、专业的Oracle案例资源汇总之案例:Oracle报错ORA-19693: backup piece %s already included本文由大师惜分飞原创分享，网址：http://www.oracleplus.net/arch/361.htmlOracle研究中心关键词：Oracle报错ORA-19693ORA-19693: backup piece %s already included
