Re: ORA-01578 system index

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 14 Mar 2003 00:41:39 +1000
Message-ID: <Uy%ba.2445$LT.7042@newsfeeds.bigpond.com>

"10Squared" <news_at_firewallinabox.com> wrote in message news:X8%ba.27807$iQ6.12791_at_fe04.atl2.webusenet.com...
> We have a corrupt data block with the following characteristics:
>
> Segment_name: I_OBJ2
> Segment_type: INDEX
> Owner: SYS
> Tablespace_name: SYSTEM
> Table_owner: SYS
> Table_name: OBJ$
>
> The file is #1, system01.dbf and block number is 25822. The database is
> running in ARCHIVELOG mode. What is the best route to a solution? TIA.
>
> Cheers,
>

Hi Jim,

Shutdown the DB, restore the datafile and recover it with a mounted database. Then open and vola !!

Hopefully your backup doesn't contain the corruption, DBV should tell you ....

It's bedtime, someone else might mention using RMAN to recover just the stuffed block (if you're on 9i and using RMAN backups)

Good Luck

Richard Received on Thu Mar 13 2003 - 08:41:39 CST