Re: Huge Partitions and Indexes, maybe compression

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 30 Mar 2004 20:49:39 +1000
Message-ID: <0bc201c41644$b364ee60$0100000a@FOOTE>

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_at_comcast.net>
To: <oracle-l_at_freelists.org>
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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 30 2004 - 04:42:35 CST