Re: Examples of setup for 5TB Oracle DB?

Hi from Paris

here, you will have a real Oracle database in terms of size... But 5Tb is not exceptional.

I think the main pitfall will be the scalability of your application. Will it be able to manage such a volume ?? You must know that as volume an user activity is growing on a given system, if scalability is not linear, you won't be able to support more load even by adding hardware.

In your case, you should be prepared to made some kind of benchmark.

After production, you will certainly face some backup strategy problems.

In Europe, largest Oracle DB is 40 To size, and is getting 40 Go a day. The only possible solution to backup this was to use RMAN, using incremental, RO tbs, and multiple channels.

Cdlt

"Frank Foss" <fozzie_beer_at_hotmail.com> a écrit dans le message de news:b9elak$ii2et$2_at_ID-190416.news.dfncis.de...
> Greetings!
>
> Have any of the honored group regulars implemented a server /cluster for
> running a 5TB Oracle9i database recently?
>
> I am looking for examples, what configurations worked for you, what didn't
> work, pitfalls and so on on the hardware side.
>
> My department is expected to come up with a proposal to be used in
> discussions with a prospective client. We have guessed/estimated the data
> growth to be around 3GB per day(at least), and they envision 5 years of
> online data. That brings the total up to around 5TB, give or take a few.
>
> The largest existing installation running our software is around 288GB,
> running on a Compaq cluster, 2 ES40 nodes and a Compaq SAN. It runs fairly
> well.
>
> The new customer likes Sun/Solaris, we have more experience with HP/HP-UX.
>
> I was thinking along the lines of a 4-node Sun Fire V480 4x900MHz CPU, 8GB
> RAM each, connected to some EMC Symmetrix/Clariion system.
> Running Oracle9i RAC, in a 4 active configuration. (is 3 active/1 standby
> nodes "better")
>
> Personally, I think the Dell/Linux/EMC+Oracle RAC 4-node clusters look
> pretty sweet, but I don't really want to jeopardize the contract by
> suggesting it to an important client...
>
> Money may not be the limiting factor, but massive overkill may not do it..
>
> Any thoughts?
>
> Foz
>
>
>
>
Received on Thu May 08 2003 - 19:28:37 CDT