Re: Backup & Recovery

Hi,

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:

> 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
Received on Sun Mar 19 2000 - 00:00:00 CST