Re: recovery strategies for multi-terabyte database

"Anton Dischner" <nospam_at_nospam.org> wrote in message news:100820041402166901%nospam_at_nospam.org...
> Hi Rob,
>
> no matter what you do. If some important piece is failing you are out
> of uptime.
>
> What you want is "shared nothing".
> 2 complete identical boxes.
> If there is a problem/update one is down, the other is running.
>
> Harddisc are becoming cheaper and cheaper
>
> Doing this for > 12 years now with a good sleep at night.
>
> kind regards,
>
> Toni
>
> PS: i do not handle terrabytes, but mission critical
>
> PPS: ... just playing around with Oracle 10g with 100 GB database on a
> 1,5 GHz box.
>
> > we are interested to know what DBAs have selected as realistic recovery
> > (and corresponding backup) strategy for a database with multiple
> > terabytes of data.

For large mission critical systems:

EMC Snapview once a week or month.
RMAN incrementals during weekdays to local disk. Save your archive logs to tape (2 copies) shipped offsite. Received on Wed Aug 11 2004 - 06:35:06 CDT