No compression SDLT220

[Nhico]

Hi to all experts,

I need some advice.

I'm trying to backup my 136GB database (offline) using one single media (SDLT1) but it keeps asking me to insert 2nd media to continue. Though it's only 109 gb had only been backup. I thought 136 can stll be consider (either 120+)coz i'm still not yet in the place where compression is working? If the the said tape drive can only backup 120+ that will be okay, but 109GB is not acceptable.

Ant idea? please help..
Thanks..

My specs:

HPUX11i
HPSDLT220

SAP CONFIGURATION:
TAPE SIZE = 100000.000 MB BACKUP MODE=FULL / OFFLINE COMPRESS=HARDWARE
ERROR: 2nd tape is needed / IO error

LOGS:

BR001I ****************************************
BR202I Saving /oracle/CHN/sapdata1/roll_1/roll.data1
BR203I to /dev/rmt/4mn ...
#FILE..... /oracle/CHN/sapdata1/roll_1/roll.data1
#SAVED.... roll.data1 CHNB03/80
BR280I Time stamp 2005-09-15 22.04.37
BR063I 77 of 103 files processed - 109163.289 MB of 135971.480 MB done
BR204I Percentage done: 80.28%, estimated end time: 22:50
BR001I ****************************************
BR202I Saving /oracle/CHN/sapdata7/roll_2/roll.data2
BR203I to /dev/rmt/4mn ...
BR278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/CHN/sapdata7/roll_2/roll.data2 of=/dev/rmt/4mn':
7378+0 records in
7377+1 records out
I/O Error

[Thayanidhi]

Hi,
It may not be always possible to achieve 220GB! Depends on data type you may get around 110GB to 220GB in SDLT1.
Sometimes beyond 220GB also possible.

Read below link for more information.

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=lpg50244&locale=en_US

May be the media/drive is poor.

Regds
TT

[Mike Reznak]

Hi,

as I understand, you don't use any compression. In that case you can backup only 110GB.

http://www.craystone.com/dealer/tandbergsdlt220a.html

Mike

[Scott McIntosh_2]

What stape patch level are you at? If not at a minimum level where SDLT 220 support was added, compression might not be getting enabled. Additionally, is the drive reporting as a COMPAQ or HP SDLT 220 drive?

Whether or not hardware compression is enabled should be easy enough to test. Download the performance assessment tool (PAT) and run that. If you get 11MB/s, that's native, no compression. If using 2:1 compressible data and you get 22MB/s, then you are getting hardware compression with that device file.