corrupt blocks WHAT WOULD YOU DO?
From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 8 Mar 2018 12:09:38 +0000
Message-ID: <CAPCNhx2A8pMySbiEDSqfU0AQF_Zo3yT+W+peZ9u+a7nJOzqoYg_at_mail.gmail.com>
RH EL 5
Oracle 11.2.0.4
Date: Thu, 8 Mar 2018 12:09:38 +0000
Message-ID: <CAPCNhx2A8pMySbiEDSqfU0AQF_Zo3yT+W+peZ9u+a7nJOzqoYg_at_mail.gmail.com>
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
--http://www.freelists.org/webpage/oracle-l Received on Thu Mar 08 2018 - 13:09:38 CET