Re: ORA-01578 system index

From: Tanel Poder <tanel_at_@peldik.com>
Date: Thu, 13 Mar 2003 16:03:07 +0200
Message-ID: <3e708ee7$1_2@news.estpak.ee>

Hi!

> 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)

Go as Richard suggested, but usually it'd be good to verify your datafile or datafiles using dbverify to check whether you have any more corruptions in them.

Also, you should try to find out, why this corruption happened, by checking alert log and OS logs about IO for instance. Because this might not be the first and last corruption.

Tanel. Received on Thu Mar 13 2003 - 08:03:07 CST