From dgoulet@vicr.com Tue, 28 Aug 2001 06:03:37 -0700 From: dgoulet@vicr.com Date: Tue, 28 Aug 2001 06:03:37 -0700 Subject: Re:How fast are your tape backups? Message-ID: MIME-Version: 1.0 Content-Type: text/plain J.C. and Sinardy, I'll try to compress two threads into one since they are almost identical. Backing up the database to tape can be a major pain and time consumer if you allow the backup software to do the data compression for you. Hardware compression done inside the tape subsystem is always faster since your using cache ram outside of your system and dedicated chips for the purpose. Therefore to get your SA's or Operators off of your backs try it that way. If your on a UNIX type of system you'll notice several device files for the tape drive, use lssf to see what each is set up for and use the one that allows the drive to do the compression. I know NT does not allow that, but I believe Tivoli does have a 'switch' that will force the compression onto the drive. Dick Goulet ____________________Reply Separator____________________ Author: "J.C. Stofer" Date: 8/27/2001 5:05 PM Hello list. I have a brand new database that is around 200 GB in size. Our tape backup solution which was supplied by the hosting company is only giving me bewteen 6 and 7 MB per second . A full cold backup can take 8 to 10 hours at this rate. I looked at the specs for the tape library they sold us and it says 15MB/sec or up to 30 MB/sec compressed. What gives? The storage is SCSI 3 and also some Fibre channel so I don't think the drives are the bottleneck. What kind of numbers are other people getting? The system NT 4 4GB RAM 400 GB storage (mix of SCSI 3 and fibre) Oracle 8.1.6.3.0 ~ 200 GB in Oracle data files Tivoli Storage Manager IBM robotic tape library (via fibre) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: J.C. Stofer INET: stoferj@columbus.rr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).