Re: Need to optimize LARGE Oracle DB backup

2004-04-06 16:51:45
Subject: Re: Need to optimize LARGE Oracle DB backup
From: "Tantlevskiy,Sergey,GLENDALE,GLOBE Center AMS" <Sergey.Tantlevskiy AT US.NESTLE DOT COM>
Date: Tue, 6 Apr 2004 13:46:35 -0700

Here is the list of the things to check:

(1) make sure hardware compression is enabled on your tape drives
(2) make sure TSM does NOT compress data
(3) Oracle server should have enough CPU power to push data, especially if
MTU size is set to 1500 - monitor CPU usage during backups
(4) as for TSM TCPIP settings, TCPWINDOWSIZE (both on the TSM Server and for
TSM API set to 128KB and TCPBUFFSIZE (client, dsm.sys) set to 32KB should be
close to perfect
(5) increase TXNBYTELIMIT (this is BA/API option, mine is set to 100MB, you
might consider increasing it even more)
(6) utilize TSM capability to write to 'null device class' (there is a brief
info about this on ITSM support page) to identify bottlenecks

We were able to achieve 36MB/s throughput per stream backing up to IBM LTO 1
(though we backup DB2, not Oracle, but it does not matter here).


-----Original Message-----
From: David Nicholson [mailto:David_R_Nicholson AT WHIRLPOOL DOT COM]
Sent: Tuesday, April 06, 2004 10:27 AM
Subject: Need to optimize LARGE Oracle DB backup

Hi List,

        I have a 700GB Oracle DB to backup every day. It's a 4.3 AIX
box...soooo LAN Free not an option for my TSM 5.2.2 server. I have
dedicated GB nic's on both the TSM client and TSM server. The network
between them is not over utilized. I am backing up directly to FC LTO II
drives.  Can anyone give me some strategy suggestions on how to get this
backed up as quickly as possible.  Suggestions for performing multiple
thread backups or maybe some TCPIP client options that can be tuned or
anything else you could suggest would be greatly appreciated.

Thanks in advance!

Dave Nicholson
Whirlpool Corporation

<Prev in Thread] Current Thread [Next in Thread>