Re: Australian trip.

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 7 May 2003 19:52:39 +0100
Message-ID: <3eb95d41_1@mk-nntp-1.news.uk.worldonline.com>

"Guy G" <ggallagher_at_espeed.com> wrote in message news:470e4f07.0305070927.6a95712b_at_posting.google.com... <snip>
> Trick question:
>
> Design a reasonable backup strategy, given the following:
>
> - Your datafiles total 345 GB
> - You have 170 GB of disk available for backups
> - Tape backup is not an option
> - Your redo logs switch 5-6 times per hour; size is 200MB
> - Database must be online 24 X 7, or close to it
>

OK; I'll bite. Are you running Oracle?

Buy some more disk space for starters. Then a tape drive; or some way of moving the hot backups and archived redo elsewhere. If the above constraints are immutable, then quite frankly I don't see a sensible backup strategy available.

Why is this a trick question? What am I missing?

Regards,
Paul Received on Wed May 07 2003 - 13:52:39 CDT