Re: VLDB Backup Solutions

Jonathan Lewis wrote:
>
> Raymond Smith wrote:
> >
> > I am beginning a project to evaluate Oracle Backup Tools including the
> > tape software and hardware. We will eventually (end of 98) need to
> > backup 1-2 TB of data in a 2-3 hour time span. Is there anyone who has
> > already done this? Anyone using Spectra Logic? Anyone using
> > SQL*Backtrack? Anyone using AXXiON-NetBackup? I would appreciate any and
> > all responses.
> >
> > Thanks,
> >
> > Raymond Smith
> > Sr. Database Analyst
> > Andersen Consulting @ Texas Instruments
> > email address: smithray_at_ti.com
>
> Addressing your problem in a different way:
>
> Does the whole 1-2 TB change between backups. Could you re-arrange
> you physical design so that a very large fraction of the database
> is in read-only tablespaces ?

I would assume the 2-3 hour timeframe is the maximum time that a database is offline for backup purposes. Using the hot backup method you would not need to shutdown your database for a backup. However, it would probably be a good idea to do an offline backup once in awhile.

I work with the OpenVision Netbackup product. So if you'd like more information on it send me an email. Received on Sat Feb 08 1997 - 00:00:00 CST