rman - fileperset and setsize-parameters are ignored

From: Andreas Kaltenrieder <akal_at_gmx.net>
Date: 23 Aug 2001 10:45:17 +0200
Message-ID: <slrn9o9gkj.e7d.akal@wceh00m2.post.ch>

Hi all,

I've got a 900GB-Database (450 2GB-files) which I backup with the following statement:

run {

   allocate channel t1 type 'SBT_TAPE';
   allocate channel t2 type 'SBT_TAPE';
   sql "alter database backup controlfile to trace";    backup
   incremental level 0

     format 'level_0_%d_t%t_s%s_p%p'


     (database);

     sql "alter system archive log current";
     backup
     format 'archive_%d_t%t_s%s_p%p'
     filesperset 20
     setsize=40000000


     (archivelog all delete input);

     release channel t1;
     release channel t2;

   }

The problem is the filesperset parameter and the setsize parameter are both ignored. It created backup sets containing only four fileperset. I've attempted to adjust these parameter to various different values, however the behavior i s always the same. It produces the following output:
[....]

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=106 devtype=SBT_TAPE
RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 - Release 3.2GA

[....]

RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=12957 set_stamp=438429546 creation_time=22-AUG-01
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00028 name=/vol05/DB1/ts1_03_09.dbf
RMAN-08522: input datafile fno=00018 name=/vol08/DB1/ts2_02_09.dbf
RMAN-08522: input datafile fno=00014 name=/vol07/DB1/ts2_01_09.dbf
RMAN-08522: input datafile fno=00012 name=/vol06/DB1/ts2_11_09.dbf
RMAN-08008: channel t2: starting incremental level 0 datafile backupset
RMAN-08502: set_count=12958 set_stamp=438429547 creation_time=22-AUG-01
RMAN-08010: channel t2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00029 name=/vol05/DB1/ts1_03_10.dbf
RMAN-08522: input datafile fno=00019 name=/vol08/DB1/ts2_02_10.dbf
RMAN-08522: input datafile fno=00015 name=/vol07/DB1/ts2_01_10.dbf
RMAN-08522: input datafile fno=00013 name=/vol06/DB1/ts2_11_10.dbf
RMAN-08013: channel t1: piece 1 created

[...]

Does anyone know about this?

Thx
Andreas Received on Thu Aug 23 2001 - 03:45:17 CDT