Question:

> 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

Answer:

What I have tried to do in the past was run the database in ARCHIVELOG mode to
save the  redo logs for recovery.  We tried to do nightly online backups to tape
via ADSM and also backed up the archived redo logs to tape frequently enough to
to keep the "archiver stuck" error from occurring (when the archive area fills
up and the redo logs can't be written to disk -- oracle suspends itself until
space is cleared).

I like to get offline backups weekly, but have settled for monthly at my
clients' insistence.

A better alternative would be to use something like EMC disks (pricey yes, but
they will eventually match other competetive prices to save a sale) with
Business Continuance Volumes (BCVs) which are essentially a spare mirror which
they take offline nightly and do a backup of your database, then put it back
online allowing it to re-sync with minimal impact to your system).

Legato, I've used for only small databases, and only if I can't avoid it.
Oracle includes only a small subset of their product with their install CDs.

I hope this helps some/

john

Mike wrote: