Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Australian trip.

Re: Australian trip.

From: Guy G <ggallagher_at_espeed.com>
Date: 13 May 2003 06:53:21 -0700
Message-ID: <470e4f07.0305130553.59c614bc@posting.google.com>


yamahasw40_at_latinmail.com (Schmuck) wrote in message news:<24819cc3.0305081354.532434c4_at_posting.google.com>...
> wizofoz2k_at_yahoo.com.au (Nuno Souto) wrote in message news:<73e20c6c.0305071358.4c587c7b_at_posting.google.com>...
> > ggallagher_at_espeed.com (Guy G) wrote in message news:<470e4f07.0305070927.6a95712b_at_posting.google.com>...
> >
> > > - Your datafiles total 345 GB
> > > - You have 170 GB of disk available for backups
> > > - Tape backup is not an option
> > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> > Praying is always an option...
> >
> > Failing that, you could look at using compression?
> > Oracle data files usually compress more than 50:1.
> >
> >
> > > - Your redo logs switch 5-6 times per hour; size is 200MB
> >
> >
> > Definitely compression will be needed!
> >
> >
> > > - Database must be online 24 X 7, or close to it
> >
> > Cool. Another exercise in fitting
> > large animals through eyes of needles?
>
> Just finished fitting said animal through said eye of needle on
> another customer site... but you need a wad of cash to do it.
>
> What we ended up doing was sticking in an HP Eva and using its
> Snapclone facility to copy the (marked) database while it stayed live.
> This meant the db was only marked for about 20 minutes a day. The
> clone of the 1.5TB DB took about 12 hours. The clone was then mounted
> on another box and ran off to tape. (StoTek L700e with 8 SDLTs).
>
> Redo logs went to tape directly.
>
> If I had my time again I would look at an alternative to the HP Eva..
> the product doesn't feel mature... but then it was one of those horror
> jobs where the client had already bought all the bits of lego and
> "just needed somebody to put it all together".
>
> Matt

Final note of thanks to all for your help. However this works out (time will tell), at least I've learned something.

Received on Tue May 13 2003 - 08:53:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US