Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01578 system index
"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