RMAN 中的maxpiecesize参数有没有最小值限制

显示全部楼层 · 2005-10-30 17:05:33

在进行备份时，当这样设置时
allocate channel dev1 type disk maxpiecesize=10M
会报错：
RMAN-03009: failure of backup command on dev1 channel at 03/21/2006 10:16:51
ORA-19504: failed to create file "/home/oracle/test_level0_585656207"
ORA-27038: skgfrcre: file exists
当allocate channel dev1 type disk maxpiecesize=1G
此时备份正常

千问 · 2005-10-30 17:05:33

备份执行脚本
RMAN> run
2> {
3> allocate channel dev1 type disk maxpiecesize=1G;
4> sql 'alter system archive log current';
5> backup
6> incremental level 0
7> format '/home/oracle/test1_level0_%t'
8> database;
9> release channel dev1;
10> }

千问 · 2005-10-30 17:05:33

RMAN> show all;
using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/ora9/product/9.2/dbs/snapcf_ora9i.t

千问 · 2005-10-30 17:05:33

详细错误信息：
RMAN> run
2> {
3> allocate channel dev1 type disk maxpiecesize=10M;
4> sql 'alter system archive log current';
5> backup
6> incremental level 0
7> format '/home/oracle/test1_level0_%t'
8> database;
9> release channel dev1;
10> }
11>
using target database controlfile instead of recovery catalog
allocated channel: dev1
channel dev1: sid=16 devtype=DISK
sql statement: alter system archive log current
Starting backup at 21-MAR-06
channel dev1: starting incremental level 0 datafile backupset
channel dev1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00009 name=/opt/ora9/oradata/ora9i/users01.dbf
input datafile fno=00011 name=/opt/ora9/oradata/ora9i/perfstat.dbf
input datafile fno=00001 name=/opt/ora9/oradata/ora9i/system01.dbf
input datafile fno=00002 name=/opt/ora9/oradata/ora9i/undotbs01.dbf
input datafile fno=00005 name=/opt/ora9/oradata/ora9i/example01.dbf
input datafile fno=00010 name=/opt/ora9/oradata/ora9i/xdb01.dbf
input datafile fno=00006 name=/opt/ora9/oradata/ora9i/indx01.dbf
input datafile fno=00003 name=/opt/ora9/oradata/ora9i/cwmlite01.dbf
input datafile fno=00004 name=/opt/ora9/oradata/ora9i/drsys01.dbf
input datafile fno=00007 name=/opt/ora9/oradata/ora9i/odm01.dbf
input datafile fno=00008 name=/opt/ora9/oradata/ora9i/tools01.dbf
channel dev1: starting piece 1 at 21-MAR-06
channel dev1: finished piece 1 at 21-MAR-06
piece handle=/home/oracle/test1_level0_585660856 comment=NONE
channel dev1: starting piece 2 at 21-MAR-06
released channel: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev1 channel at 03/21/2006 11:34:20
ORA-19504: failed to create file "/home/oracle/test1_level0_585660856"
ORA-27038: skgfrcre: file exists
Recovery Manager complete.

千问 · 2005-10-30 17:05:33

最初由 jyj 发布
[B]在进行备份时，当这样设置时
allocate channel dev1 type disk maxpiecesize=10M
会报错：
RMAN-03009: failure of backup command on dev1 channel at 03/21/2006 10:16:51
ORA-19504: failed to create file "/home/oracle/test_level0_585656207"
ORA-27038: skgfrcre: file exists
当allocate channel dev1 type disk maxpiecesize=1G
此时备份正常 [/B]
该备份文件没有1G这么大，所以设置成1G是没问题的，
当10M时，其需要再创建第2个备份文件，但名字却是和
第1个一样，因为你已经固定文件名。所以报文件存在错误。

千问 · 2005-10-30 17:05:33

最初由 ZALBB 发布
[B]
该备份文件没有1G这么大，所以设置成1G是没问题的，
当10M时，其需要再创建第2个备份文件，但名字却是和
第1个一样，因为你已经固定文件名。所以报文件存在错误。 [/B]
但是使用了时间戳呀。%t

千问 · 2005-10-30 17:05:33

加了%p，使生成的备份文件名不重复，问题解决。

千问 · 2005-10-30 17:05:33

最初由 jyj 发布
[B]
但是使用了时间戳呀。%t [/B]
这就是说%t的变化太慢，也就是说精确度不够了。

千问 · 2005-10-30 17:05:33

最初由 cjf107 发布
[B]
这就是说%t的变化太慢，也就是说精确度不够了。 [/B]
%t%s这样也不行，必须加上%p

千问 · 2005-10-30 17:05:33

%u和%U也可以