Re: How are you backing up your V,VLDB????

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<b19q9b$23f$1$8302bc10_at_news.demon.co.uk>...
> I think the most significant strategic point
> is that a database of this sort is almost
> always susceptible to partitioning, with
> a date-based partition. So a large fraction
> of the database can be put into read-only
> tablespaces.

That's indeed true. However, I would want to add one more "the most significant strategic point" and that's proper analysis of real needs.
Something like: Do we really need all this data loaded in our database and stored for next hundred of years?

In past I've encountered few times some databases specially data warehouses, where its proud owner told me: "We're storing 2TB right now and it will grow even further". And after that I've realized that inside is a lot of irrelevant crap, which is inside just because "maybe we will need this one day" and no one was enough brave to told managers that this particular information is an useless piece of sh*t. Not mentioning redundant data, because data model is bad and/or data cleaning was not sufficient or is not implemented at all.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.