Re: corrupt blocks WHAT WOULD YOU DO?

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 9 Mar 2018 12:07:50 +0700
Message-ID: <CAP50yQ-HXZHH61ge9NtiSP5ii=_h1QeM8dFpz0UOSLX7dMDq_w_at_mail.gmail.com>



"bootstrap" objects are the objects listed in bootstrap$.

They can still be rebuilt, but they are protected internally. The database must be in upgrade mode - then changes to those objects are allowed.

On Fri, Mar 9, 2018 at 7:54 AM, MacGregor, Ian A. <ian_at_slac.stanford.edu> wrote:

> I hads a primary database server crash one time and an index having to do
> with clustered tables was clobbered such that the index and the table were
> in disagreement. I was told by Oracle support that the index couldn't be
> rebuilt as it was a "bootstrap" object which I took to mean anything
> built by calling sql.bsq; i.e, the data dictionary. The physical standby
> was in good shape, I cannot remember if we switched over of failed over.
>
>
> The old primary was fine except when the indexed was called.
>
>
>
> Ian A. MacGregor
> SLAC National Accelerator Laboratory
> Computing Division
> To offer the best IT service at the lab and be the IT provider of choice.
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Stefan Knecht <knecht.stefan_at_gmail.com>
> *Sent:* Thursday, March 8, 2018 4:25:45 AM
> *To:* Howard Latham
> *Cc:* ORACLE-L
> *Subject:* Re: corrupt blocks WHAT WOULD YOU DO?
>
> What is the name of the object?
>
> I wouldn't accept Oracle's "fix" either way. If it's an index, regardless
> of what index it is, it can be dropped and re-created to rid of the corrupt
> blocks.
>
> Smells like they're looking for the "easy way out" here.
>
> Stefan
>
>
>
> On Thu, Mar 8, 2018 at 7:09 PM, Howard Latham <howard.latham_at_gmail.com>
> wrote:
>
> RH EL 5
> Oracle 11.2.0.4
>
> I have corrupt blocks in the sysman ts. Oracle tell me to rebuild my
> database. Its 1/2 TB and I don't really want the downtime.
> Its in a MGMT Flow index which I don't think we use anyway and the index
> is disabled.
> I don't have an RMAN backup old enough to repair.
> What would you do?
>
> I do have two plans
>
> Turn on flashback and try dropping and recreating the objects.
>
> Its an IOT so cant be rebuilt online.
>
> Other plan - Ignore it. Does it matter?
>
> I seem to recall many years ago being told by Oracle to rebuild the AUD$
> table index which had corrupted and caused logins to fail.
>
> Best Wishes
>
> Howard A. Latham
>
>
>
>
>
> --
> //
> zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
> Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat
> | _at_zztat_oracle
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
_at_zztat_oracle

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 09 2018 - 06:07:50 CET

Original text of this message