Re: Huge Partitions and Indexes, maybe compression
- From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Mar 2004 20:49:39 +1000
Something that hasn't kinda been stated yet is a rethink in your backup and
recovery strategy. If the times to rebuild a huge index are restrictive in
terms of the performance issues that might eventuate while you re-create the
corrupted index, you may need to seriously consider having a backup of your
indexes. Then a recovery of a corrupted index can consist of a relatively
fast datafile or block restore and subsequent recovery.
Increase storage requirements, yes, but also increased recovery times as
well.
Cheers
Richard
----- Original Message -----
From: <mkline1@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, March 30, 2004 5:58 AM
Subject: Huge Partitions and Indexes, maybe compression
> We're HP-UX and Oracle 8.1.7.4.
>
> We've got some BIG partitioned tables, but got to thinking. They want to
keep 5 years. If down the road we get to perhaps 400-800gb in some of these
and an index gets corrupted, what can we do about it? The table will be so
large we'd never be able to rebuild.
>
> There is a thought we could use compressed indexes and that may help a
bit, but as far as I know, there are no compressed tables yet.
>
> Even so, does that eliminate the problem?
>
> Once these things get built that large what can one do about a rebuild? It
would take days to reload the table. Do the matching indexes stay so
isolated from the other partitions that rebuilding the index would only be
one partition and this is of little concern?
>
>
>
> --
> Michael Kline, Principle Consultant
> 804-744-1545
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
