本帖最后由 lujiaguai 于 2016-6-21 11:29 编辑
没有指定全局参数的情况下
configure channel 1 device type disk maxpiecesize 100m;
尝试执行外脚本
Run
{
allocate channel c1 device type disk maxpiecesize 100m format "/u01/app/oracle/backup/%u.bkp";
backup tag '0620.systempieceincr0.1' incremental level 0 tablespace system;
}
备份的结果有一个报错，但是依然可以看到备份集，大小只有59M左右
Starting backup at 2016-06-21:11:19:50
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.257.914002203
channel c1: starting piece 1 at 2016-06-21:11:19:50
channel c1: finished piece 1 at 2016-06-21:11:19:53
piece handle=/u01/app/oracle/backup/64r8mnem.bkp tag=0620.SYSTEMPIECEINCR0.1 comment=NONE
channel c1: starting piece 2 at 2016-06-21:11:19:53
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 06/21/2016 11:19:54
ORA-19504: failed to create file "/u01/app/oracle/backup/64r8mnem.bkp"
ORA-27038: created file already exists
Additional information: 1
外脚本应该怎么处理？
是不是需要指定全局参数：configure channel 1 device type disk maxpiecesize 100m;
然后在执行run，run中不写maxpiecesize参数，这样可行吗？
在11G下，可否不写全局参数，直接用section size 来做？
我尝试过直接写
Backup tag '0621.piece' section size 100m incremental level 0 tablespace system;
结果也是报错，为什么？
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/21/2016 11:29:54
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect
| 
发表于 2016-6-21 11:25:56
发表于 2016-6-22 09:51:19
