Hi All,
We currently have a large 2.6TB (ever growing) SAP database that we perform a full hot archive on each day. The primary DB server sync's a BCV mount, and then we backup the mirror directly on the TSM server. The TSM server is an IBM H80 running AIX 5.1.0.5, TSM Server 5.2.2.0, and connects to a 3494 library that contains 10 3590EA1 drives. This backup generally takes about 12-13 hours to complete. The backup is setup to use 4 drives for the primary copy, and additional 4 to copy to the offsite pool simultaneously.
I know an incremental backup would help somewhat with media consumption, but not all that much since we expire the data every 14 days and get a return on the media. I have been asked by management if moving to an incremental backup would help performance? Does anybody have any experience backing up an SAP Oracle DB of this size incrementally? What is the best performing cost effective way to backup 2.6TB?
Any insight would be much appreciated!
Thanks,
Greg