Re: Very Large Oracle Database Backup (200 Gbytes)

byron_at_sfsu.edu writes:

>Vincent Catry <catry_at_grenoble.hp.com> wrote:
 

>>Hello
 

>>Does anyone has experience in backuping big Oracle database
>>(200 Gigbytes) ? I was thinking of doing one full & offline backup
>>on saturday night on many different tape devices in parallel and
>>backup archive log files continuously during the week for the
>>incremental. But I am afraid of the recovery time of those archive
>>log files.
 

>>Any feedback ?
>>Thanks
>>catry_at_grenoble.hp.com
 

>Ours is not quite so large (only 40GB - about 70 GB next year). We
>take an offline backup (about 2 hours on 3480 media; compressed;
>parallel dumps on multiple drives) during the weekend mainly to get
>the control files and database in for a disaster recovery set. We use
>hotbackup and archive logs during the week for incrementals. You are
>right about the recovery time concern - it takes an enormous amount of
>time for Oracle to unscramble itself even from just a "basic" crash.
>Without the combination of on-line archive logs and near-on-line tape
>logs - a tape only solution would be ridiculous.
 

>I noticed your org is hp.com. We are considering HP for specialty
>database servers. Any suggestions for how many tape drives for a 100+
>GB database? I was thinking 3490E (if even possible) or DLT. What is
>your experience on the DLT or other recommendation for FAST tape
>systems for HP.
 

>Thanks.
>Byron
>byron_at_sfsu.edu
>Administrative Systems

Ok, slightly on the ignorant side, but what are 3490E, 3480 and DLT it currently takes us over 8 hours to backup 2 gigs of Oracle system using fbackup on an 800 series HP. We are concerned (more than a bit) than when our database starts growing in earnest, it will become impossible for us to make backups. Any suggestions anyone.

Jim T

-- 
   ~)~.      ~)~   _   _ |_    ||    || ||\ || || || \\ // 
 (_/ / /')   / (' / ) (_ | )   ||    || ||\\|| || ||  )X(  
 Wolverhampton Polyversity     ||__| || || \|| \\_// // \\ 
 E_MAIL cm5585_at_scitsc.wlv.ac.uk           UNIX++