Re: Backup & Recovery

I would suggest the following :

1. By the cloning option with Vertias
2. Providing you have enough space (which is not much really), clone you database to disk.
3. This can be done hot
4. Keep 1 or 2 copies it online (disk) and take the rest offline via high speed switch (GigaByte) to DLT or equiv.
   • make sure you are using at least RAID 1/0 OR 0/1

200Gb - not long if you have as an example 4 DLT heads to write in paralell.

Cheers,
Stephen

Jerry Gitomer <jgitomer_at_erols.com> wrote in message news:953530345.2123499795_at_news.erols.com...
> On Sun, 19 Mar 2000, Mike wrote:
> >Hi
> >
> >Could any one offer suggestions on the followings for a 200 GIG 24x7 OLTP
> >database ofcourse under SUN Solaris (Sparc) :-
> >
> >1) What should be the best back up strategy - daily,weekly,monthly
 incl :
> >to
> > minimize mean time to recover, etc).
> >2) What Media Tape hardware would be best ( hardware for backup)
> >3) How about Legato ( of ASDM)
> >4) How long the full backup would take for 200 gig (Only an expert guess
> > would do)
> >
> >All suggestions are welcomed
> >
> >Tks so much for your time
> >
> >Mike
>
> The client site I am currently working in backs up to disk every
> night and then goes disk to tape. It takes less than five minutes to
backup
> 40GB. It then takes several hours to copy the backups to tape.
>
> If you can afford the additional disk capacity you should investigate
> this strategy.
>
>
> --
> Jerry Gitomer
> Once I learned how to spell DBA, I became one
>
Received on Mon Mar 20 2000 - 19:30:37 CST