Re: Backup for VLDB

Answers inline:

On Fri, 06 Apr 2001, Nosie wrote:

>The data size could be as large as 150GB. We never have the

We have several database ranging from ~400GB to over a terabyte. We back up to tape using hp omniback (~70gb per tape). Takes anywhere from 4 to 12 hours, depending upon the number of drives available at the time.

> 2. How large is the size of each backup file? What UNIX can handle more than
> 2 GB file reliably?

Any 64-bit *nix can handle it (hpux, tru64, etc). No real (reachable) outer size limit (ok, it reachable, but you'd have to try damn hard :)

> 3. How long will the backup process take time (in hours?), just roughly, I
> need your scientific guess.

See above.

Cheers,
GC

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gregory Conron
  INET: gconron_at_hfx.andara.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).