ORA-01578: ORACLE data block corrupted

[Former Member]

Hi,

In system log we found database error, how to repair the corrupted data block in ORACLE.

Database error 1578 at SEL access to table BDCPS

> ORA-01578: ORACLE data block corrupted (file # 10, block #

> 253395)#ORA-01110: data file 10:

> '/oracle/JID/sapdata2/sr3_7/sr3.data7'

SQL> SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id = 10 and 253395 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE       OWNER

------------------------------ ------------------ ------------------------------

SEGMENT_NAME

--------------------------------------------------------------------------------

PSAPSR3                        TABLE              SAPSR3

BDCPS

Now what activity i have to do..

[Former Member]

Hi,

As said by Stefan, check whether you have valid backups which can be restored!

Regards,

Nick Loy

[stefan_koehler]

Hi Ram,

> Now what activity i have to do..

Praying for a valid and consistent backup (without that block corruption). If you have one, you can do an online block recovery (with RMAN) or do an offline full data file restore & recovery (if not using RMAN) with your backup tool.

Regards

Stefan

[former_member182657]

Hi Ram,

You've already posted same on

Regards,

Gaurav

[Former Member]

Hi,

That is for (C_OBJ# ) a cluster type.. you have given a below query to execute.

---------------------------------------------------------------------------------------------------------------------------------------

select cluster_name, table_name from user_tables where cluster_name =' C_OBJ#' order by 1;

------------------------------------------------------------------------------

Here segment type is TABLE, in this case how to check..