设为首页收藏本站

Botang唐波's Oracle Station

查看: 1216|回复: 1

备份集分片相关问题

[复制链接]

81

主题

181

帖子

779

积分

高级会员

Rank: 4

积分
779
发表于 2016-6-21 11:25:56 | 显示全部楼层 |阅读模式
本帖最后由 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

回复

使用道具 举报

730

主题

1100

帖子

7995

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7995
发表于 2016-6-22 09:51:19 | 显示全部楼层
是因为写了%u而不是%U,注意大写。


section size  就是替换maxpiecesize用的
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-10-20 03:37 , Processed in 0.155953 second(s), 23 queries .

快速回复 返回顶部 返回列表