Enterprise Manager Generic (MOSC)

MOSC Banner

MGMT_METRICS_RAW data needed?

edited Jul 10, 2009 6:21AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered
 I am getting a "ORA-01578: ORACLE data block corrupted " error in my database.  My research into this has shown the error to be in the MGMT_METRICS_RAW table, more specifically the PK for this table.  But since it is an index organized table, the PK is basically the table itself.  I cannot run the DBMS_REPAIR utility on an indexed organized table, so my choice seems to be to salvage what I can from the table, drop, then recreate.

Are there any problems/dangers in dropping/recreating this table?  It seems to be a monitoring table, I can salvage about 26000 out of the 100,000 or so recs.  The PK doesn't seem to be an FK reference from any other table.  I'm hoping that all I'll lose is a few days worth of monitoring data.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center