Richard -- I do a large Oracle/SAP database nightly, with this result:
BR077I Database file for backup: /oracle/PRD/sapbackup/cntrlPRD.dbf BR061I 487 files found for backup, total size 746281.344 MB BKI1215I: Average transmission rate was 260.748 GB/h (74.168 MB/sec). BKI1227I: Average compression factor was 1.00. BKI0020I: End of program at: Thu Feb 20 21:49:52 2003 . BKI0021I: Elapsed time: 02 h 47 min 47 sec . BKI0024I: Return code is: 0. My TSM server is an RS/6000 660-6M1 with 10 LTO tape drives in an IBM 3584 library. This backup does NOT go to disk, it goes directly to four tapes, over two gigabit ethernet interfaces. The database server is another 660-6M1, with three fiber-channel connections to an IBM ESS. Both systems are 4-way; the database server has 8 GB and the TSM server is a 6 GB system. The tape drives are SCSI, with two drives per cable; I see about 4.5 to 1 hardware compression on this backup. The gigabit ethernets are dedicated for backups (my 'backup1' and 'backup2' networks). The TSM database and disk pools are spread over two ESS arrays, with the database and recovery logs TSM mirrored between the two (yes, I'm paranoid; so?) During the backup the TSM server runs at 30 to 40% CPU usage; the SAP database server is at 70 to 90% (anyone got a clue why TDP/R3 would pound the CPU like this, when it's not doing compression? I am doing 6-way multiplexing, that may be a contributor). Tom Kauffman NIBCO, Inc -----Original Message----- From: Dearman, Richard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 9:34 AM To: [EMAIL PROTECTED] Subject: Anyone doing 1TB+ Backup Nightly I do 1TB+ backups nightly which run for about 8 hours. A large part of our backup is a 500GB Oracle database backup to TSM. The database backups up over a private 1Gb connection to a AIX P660-6h1 server with 2GB of RAM and 4 processors. The data then goes to nine 2disk stripe sets, over a 1Gb SAN connection (I went with stripe sets because RAID5 was just to slow). I'm getting high iowat times on my AIX TSM server. I'm having a hard time pinpointing exactly where the bottleneck is at. Currently it takes 51/2 hours to backup 500GB but I know it can be better. My question is are any of you that are moving this amount of data faster than me using a more powerful server like a IBM 690. THanks ***************************EMAIL DISCLAIMER*************************** This email and any files transmitted with it may be confidential and are intended solely for the use of th individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management 312.996.3941.
