Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

alter index ... rebuild was failing -> getting corrupt blocks

Database: 9.2.0.5

OS: HPUX-ia64

Hello,

i rebuilded a index, announced from UpdatStats in DB13, and get a ORA-01114: IO error writing block to file 2045 (block # 319154) and

ORA-27072: skgfdisp: I/O error in my sqlplus session.

-> i do a alter index SAPR3."xxx~0" rebuild online parallel 4 nologging;

-> System was up and running

After that, the DBVerify marked some blocks corrupt, here one example:

BR0398E DBVERIFY detected corrupted blocks in /oracle/XXX/sapdata22/btabi_95/btabi.data95

We checked all corrupted blocks - all in free space.

So we fixed that with creating a table with next extend size from the corrupted blocksize.

I think we had not enough space in the tablespace where the index is, okay ... and what we also found, the PSAPTEMP datafiles was created as SPARSE files ...!!

-> PSAPTEMP-Datafile: 10GB in the System - 2,5GB maximum on OS-Level, no more space.

But my question is why i am getting corrupt blocks when a "alter index ... rebuild ..." is failing ?!?!

Thank you for your support.

Regards,

Markus

Edited by: Markus Dinkel on Oct 9, 2008 12:56 PM

Edited by: Markus Dinkel on Oct 9, 2008 12:56 PM

Edited by: Markus Dinkel on Oct 9, 2008 12:59 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question