idl_sb4$ contains corrupted block !

[abenb...@omnidata.co.ma]

Hello all,

I had ORA-1578 & ORA-1110 when trying to connect to the db as a simple user.
I found the corrupted block in the DB dictionnary table idl_sb4$.
CAn any body show me how can I resolve this.

Regards.

Ayoub.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[Carl Bruhn]

Hi Ayoub,

we had an incident on idl_ub1$ table with corrupted block, but where able to
make a full export of the database (because sys tables is not exported during
export), recreate the database and make an import.
If you have an backup using archivelog mode, you would probably be better of by
recreating from this backup. But make an exp first if you can.

Hope this help but corrupted blocks are normally a matter of restoring from
backup.

best regards.
Carl Bruhn.
c...@dde.dk

[mark....@eds.com]

In article <36C145FA...@dde.dk>,

If you can determine the object or objects affected you probably could drop
the object then recreate it. This will work when the corruption is in the
row and not the header information of the block. We have fixed corruption in
sys.seq$ by dropping a sequence and recreating it.

Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --