RE: Oracle XE Corruption

  • From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
  • To: "'andrew.kerber@xxxxxxxxx'" <andrew.kerber@xxxxxxxxx>, "ilmar.kerm@xxxxxxxxx" <ilmar.kerm@xxxxxxxxx>
  • Date: Tue, 24 Aug 2010 15:17:05 -0400

I don't have an XE environment to test against, but on my EE test box, I was 
able to rebuild it both online and not.

_____________________________________________________________________________
Stephan Uzzell | MICROS Systems, Inc.

Database Administrator - OPERA Global Technical Services
7031 Columbia Gateway Dr,  Columbia, MD  21046 | * 443.285.8000x2760 | 7 
443.285.6505

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Andrew Kerber
Sent: Tuesday, 24 August, 2010 14:53
To: ilmar.kerm@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Oracle XE Corruption

Not sure if that is true, as I recall alter index rebuild... will fix an index 
that is in an invalid state.
On Tue, Aug 24, 2010 at 1:43 PM, Ilmar Kerm 
<ilmar.kerm@xxxxxxxxx<mailto:ilmar.kerm@xxxxxxxxx>> wrote:
Hi

Doesn't rebuilding actually use the existing index to read the data
from, so rebuild will actually hit the corruption?
From documentation:
http://www.filibeto.org/sun/lib/nonsun/oracle/10.2.0.1.0/B19306_01/server.102/b14231/indexes.htm#i1006864
"When you rebuild an index, you use an existing index as the data source."

So drop and create the index.

1. Get the index DDL using DBMS_METADATA.GET_DDL
select dbms_metadata.get_ddl('INDEX','SMON_SCN_TIME_TIM_IDX') txt from dual;

2. Drop old index: drop index SMON_SCN_TIME_TIM_IDX;

3. Run create index statement returned from dbms_metadata.get_ddl



On Tue, Aug 24, 2010 at 8:55 PM, Andrew Kerber 
<andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>> wrote:
> I suggested new tablespace in case there is physical corruption.  Moving the
> index would take it off of the bad spot.
>
> On Tue, Aug 24, 2010 at 12:47 PM, Bobak, Mark 
> <Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>>
> wrote:
>>
>> I'm not sure the new tablespace would be required either, but I'm pretty
>> sure 'online' option is out of the question, as that's an Enterprise Edition
>> only option, if I'm not mistaken.
>>
>>
>>
>> -Mark
>>
>>
>>
>> From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
>> [mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>]
>> On Behalf Of Uzzell, Stephan
>> Sent: Tuesday, August 24, 2010 1:44 PM
>> To: 'andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>'; 
>> jepettrey@xxxxxxxxx<mailto:jepettrey@xxxxxxxxx>
>> Cc: Oracle-L@xxxxxxxxxxxxx<mailto:Oracle-L@xxxxxxxxxxxxx>
>> Subject: RE: Oracle XE Corruption
>>
>>
>>
>> Wouldn't just a simple rebuild online suffice? Why move it to a new
>> tablespace if it is an object owned by SYS?

--
Ilmar Kerm
--
//www.freelists.org/webpage/oracle-l




--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: