Hello,
We have an Oracle Database 11.2.0.3, size *2.2Tb* on AIX 6.1.
There is a TSM 6.3 disk pool, size *4Tb*.
When attempting to make a compressed backupset on this pool with command:
run {
allocate channel ch01 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch02 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch03 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch04 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch05 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch06 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch07 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch08 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch09 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch10 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch11 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch12 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch13 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch14 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch15 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel ch16 device type SBT parms 'ENVTDPPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
BACKUP AS COMPRESSED BACKUPSET FULL DATABASE;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
release channel ch08;
release channel ch09;
release channel ch10;
release channel ch11;
release channel ch12;
release channel ch13;
release channel ch14;
release channel ch15;
release channel ch16;
}
the backup fails with error:
RMAN-03009: failure of backup command on ch16 channel at 11/28/2012 12:22:17
ORA-19502: write error on file "CS_20121128_qlnrehrm_1_1.DBF", block number 257 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1311E (RC11) Server out of data storage space
channel ch16 disabled, job failed on it will be run on another channel
The attempts to execute above command also failed on TSM disk pool with size *5TB*, *7TB*. But this sizes are 2-3 times larger than original DB size (2.2TB).
The final attempt of executing our command succeded on TSM disk pool of *15TB* !. During it's execution, we could monitor the disk pool usage of *~7TB*. After the backup finished, the disk pool freed and only *~100GB* of compressed backupset remained.
-----
So the question is: Is this an issue or a normal RMAN or TSM operating ?
We'll be very greatfull for your kind responses!
Regards,
iago