? ? ------- --- ----------- ----------
? ? 10152? 1? AVAILABLE? I:\BACKUP\B_NSOA_10193_UHQ39J0B_20150401
?
What is backup piece?
?A backup set contains one or more binary files in an RMAN-specific format. This file is known as a backup piece. A backup set can contain multiple datafiles. For example, you can back up ten datafiles into a single backup set consisting of a single backup piece. In this case, RMAN creates one backup piece as output. The backup set contains only this backup piece.
?接着使用change 命令uncatalog 重复的piece:
?
RMAN> change backuppiece 'I:\BACKUP\B_NSOA_10193_UHQ39J0B_20150401' uncatalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: uncatalog 命令 (在 04/10/2015 15:52:48 上) 失败
RMAN-20261: 含糊的备份片段句柄
RMAN-06092: 查找备份片段时出错
RMAN> change backuppiece 10123 uncatalog;
未将备份片段列入目录
备份片段句柄=I:\BACKUP\B_NSOA_10193_UHQ39J0B_20150401 RECID=10123 STAMP=876669065
未分类的 1 对象
RMAN> change backuppiece 10152 uncatalog;
未将备份片段列入目录
备份片段句柄=I:\BACKUP\B_NSOA_10193_UHQ39J0B_20150401 RECID=10152 STAMP=876670068
未分类的 1 对象
Uncatalog 后还原正常了,但我有些糊涂了,便想起了备份通道的问题,也就有了如下的猜测,面对大的库,备份分配多个通道执行并行备份不是显著提高备份效率吗？为什么我的备份会产生duplicate pieces,是否和多通道有关系?以下是我的备份脚本:
run{
? ? allocate channel dev type disk;
? ? allocate channel dev1 type disk;
? ? allocate channel dev2 type disk;
? ? backup incremental level 0? database
? ? format 'I:\BackUp\PRACTICE\db_%d_%s_%p_%T'
? ? tag 'WHOLE_INCL0';
? ? release channel dev;
? ? release channel dev1;
? ? release channel dev2;
}
?欢迎知情人士指导,谢谢!
--The end