Re: Oracle data block corruption error in ebs database

Posted by raiq1 on Sep 11, 2021; 2:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Oracle-data-block-corruption-error-in-ebs-database-tp10238p10250.html

Dear Erman sir,

I have used below command


SQL> select * from v$database_block_corruption;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
       352     110336        104                  0 ALL ZERO
       352     110440          1                  0 CORRUPT
       352     110441         23                  0 ALL ZERO
       352     165656      26473                  0 ALL ZERO


SQL> SELECT tablespace_name, segment_type, owner, segment_name
  2  FROM dba_extents
  3  WHERE file_id =352 and 110440 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSTEM                         INDEX              SYS
I_OBJ4

SQL> SELECT tablespace_name, segment_type, owner, segment_name
  2  FROM dba_extents
  3   WHERE file_id =352 and 110441 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSTEM                         INDEX              SYS
I_OBJ4


SQL> SELECT tablespace_name, segment_type, owner, segment_name
  2  FROM dba_extents
  3  WHERE file_id =352 and 110336  between block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSTEM                         INDEX              SYS
I_OBJ4


I have done dbv command to system09 tablespace and also resize the datafile system09 but still same issue are persist and not be able to removed corrupted block.

Kindly advice us.

Regards,