Database Administration (MOSC)

MOSC Banner

Block corruption

edited Sep 25, 2012 3:07AM in Database Administration (MOSC) 18 comments
Hi,

I am using Oracle 11.2.0.1 on Windows 2008 . I am getting the block corruption error when I select count() on couple of tables.

SQL> select count(*) from report_details;
select count(*) from report_details
                     *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 92, block # 109987)
ORA-01110: data file 92: 'F:\DATA\DEV\IXREP01_1.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option

select count(*) from comp_temp_items
                   *

ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 183, block # 167331)
ORA-01110: data file 183: 'F:\DATA\DEV\IXREP01_2.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option

Looks like the corruption occured in index tablespace called (IXREP01)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center