This discussion is archived
5 Replies Latest reply: Jan 8, 2013 3:06 AM by 598998 RSS

Oracle RMAN compressed backupset on TSM disk pool

598998 Newbie
Currently Being Moderated
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
  • 1. Re: Oracle RMAN compressed backupset on TSM disk pool
    mseberg Guru
    Currently Being Moderated
    Hello;

    The main error is ANS1311E (RC11).

    This is an error from the Media Management Vendor.

    You should contact the vendor of the media management software.

    At this point I don't believe you have an RMAN issue.

    Best Regards

    mseberg
  • 2. Re: Oracle RMAN compressed backupset on TSM disk pool
    Satishbabu Gunukula Oracle ACE
    Currently Being Moderated
    I hope you have noticed the below error, its an issue with Media management

    ORA-19511: Error received from media manager layer, error text:
    ANS1311E (RC11) Server out of data storage space

    Regards,
    http://www.oracleracexpert.com
    Send mails using UTL_SMTP in Oracle
    http://www.oracleracexpert.com/2012/10/send-mails-using-utlsmtp-in-oracle.html
    Convert Single Instance to RAC – Part1: Duplicate DB using RMAN
    http://www.oracleracexpert.com/2012/10/convert-single-instance-to-rac-part1.html
  • 3. Re: Oracle RMAN compressed backupset on TSM disk pool
    598998 Newbie
    Currently Being Moderated
    Dear mseberg and Satishbabu Gunukula,

    Thank you both for your helpfull responses!

    Could you (or someone else), please, describe me (or better give a link to docs.oracle) RMAN compressed backupset behaviour, concerning disk usage consumption during compressed backupset. I.e., the compression is done in memory, or on Disk (or sbt device) after the normal (uncompressed) backupset is done, what is the average factor of disk space needed to produce the compressed backupset, relative to the size of source DB, etc.
    And, finally, does the number of allocated channels to device matter the disk consumption? ;-)

    Regards,
    iago
  • 4. Re: Oracle RMAN compressed backupset on TSM disk pool
    mseberg Guru
    Currently Being Moderated
    Hello;

    Not sure how the algorithm works or how channels would have any effect on compression. Would assume its done in memory or the speed would suffer.

    This one shows them all and tests them so you get some idea what to expect :


    RMAN Backup Compression

    http://gavinsoorma.com/2009/12/11g-release-2-rman-backup-compression/

    And so does this :

    http://taliphakanozturken.wordpress.com/2012/04/07/comparing-of-rman-backup-compression-levels/

    And finally :

    http://www.dbspecialists.com/blog/database-backups/rman-compression-algorithms-in-11gr2/



    Best Regards

    mseberg

    Edited by: mseberg on Dec 7, 2012 3:52 AM
  • 5. Re: Oracle RMAN compressed backupset on TSM disk pool
    598998 Newbie
    Currently Being Moderated
    Hello!

    Thank you very much!

    Regards,
    iago

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points