Oracle Database Discussions

Hi,

I am having the problem with incidents size, its up to 27 gb, and all incidents are related to ORA-01578 and ORA-0110

these are five errors repeatedly:


ORA-01578: ORACLE data block corrupted (file # 11, block # 4262)
ORA-01110: data file 11: '/db/oracle/PROD/db/apps_st/data/sysaux01.dbf'

ORA-01578: ORACLE data block corrupted (file # 11, block # 4204)
ORA-01110: data file 11: '/db/oracle/PROD/db/apps_st/data/sysaux01.dbf'

ORA-01578: ORACLE data block corrupted (file # 11, block # 3772)
ORA-01110: data file 11: '/db/oracle/PROD/db/apps_st/data/sysaux01.dbf'

ORA-01578: ORACLE data block corrupted (file # 11, block # 31952)
ORA-01110: data file 11: '/db/oracle/PROD/db/apps_st/data/sysaux01.dbf'

ORA-01578: ORACLE data block corrupted (file # 11, block # 4454)
ORA-01110: data file 11: '/db/oracle/PROD/db/apps_st/data/sysaux01.dbf'

when I run the query:
select * from v$database_block_corruption;

I get the following output:


FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTION_TYPE
11 4262 1 0 FRACTURED
11 4204 1 0 FRACTURED
11 3772 1 0 FRACTURED
11 31952 1 0 FRACTURED
11 4454 1 0 FRACTURED


From further analysis I get the the following results:


Original Absolute Relalive Block# Tablespace Segment Owner
Error File# file# BL Type
&AFN and RFN
========= ======= ======== ======= =============
ORA-01578 11 11 4204 SYSAUX INDEX SYS
ORA-01578 11 11 3772 SYSAUX INDEX SYS
ORA-01578 11 11 4262 SYSAUX Table SYS
ORA-01578 11 11 31952 SYSAUX INDEX SYS
ORA-01578 11 11 4454 SYSAUX Table SYS


Database is 11g.

How to resolve this issue.

Kindly provide a feedback.

Regards,
Raza