Re: Large Backups...

Mark A. Scarton (marksc_at_wpmail.code3.com) wrote:
: lpf1_at_ahs.aberdeen.k12.ms.us (Larry Flippo) wrote:
: > I currently have a 10+ GB Oracle database running on a 4-processor
: > RS/6000 with a auto-loading tape. A complete system backup from AIX
: > takes almost 8 hours.... Is this normal? It seems long to me, but I
: > have no experience with backups this large...
 

: I'd be interesting in a general discussion of this topic as well.
 

: We have Oracle databases ranging in size from ~2Gb to ~250Gb, and in the latter
: case we're experiencing growth on the order of ~100Gb per year. Our data is
: non-purgable and non-prunable (patient health/care information), so the numbers
: will continue to mount forever. We're currently moving to Oracle 7.3.
 

: We've been looking at multiple port (SCSI) multiple drive systems. The main
: players seem to be DLT with a couple of vendor software packages and IBM's 3590

We have a 50 Gig 7x24x52 DB that we are bucking the trend with by backing up to 5 - 8mm tape drives (adding a sixth real soon now). We do hot backups in 3 hours, of the entire DB, every night, for about the last 2 years. We also append the last 6 hours of Archive logs to the end, to ensure that each set of tapes is sufficent in itself to restore and open a DB (this later is a Disaster Recover Procedure requirement).

--

_______________________________________________________________________
Peter MacDonald                           Open Systems Group
PH: (604) 389-3285                    Pharmacare Network Project
PROFS:    PCMACDON             INTERNET: pmacdona_at_tadpole.osg.gov.bc.ca
_______________________________________________________________________