Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

corrupted block

happy10319Nov 12 2009 — edited Nov 12 2009
Hi,
in 10g R2 , I have this in alertlog :
ORA-01578:datablock altered(file # 3, bloc # 30029)
ORA-01110: file 3 : 'D:\BASE\RPRMAN\SYSAUX01.DBF'
Then I try to find the corrupted table :
SQL> SELECT tablespace_name, segment_type, owner, segment_name
  2         FROM dba_extents
  3          WHERE file_id = 3
  4   AND 30029 BETWEEN block_id AND block_id + blocks - 1;
 
TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ---------------
SEGMENT_NAME
-----------------------------------------------------------------
SYSAUX                         TABLE              SYSMAN
MGMT_SYSTEM_PERFORMANCE_LOG
Then it is MGMT_SYSTEM_PERFORMANCE_LOG table.
But when I query that table :
SQL> select count (*) from sysman.MGMT_SYSTEM_PERFORMANCE_LOG;

  COUNT(*)
----------
      3342
Is ithe table realy corrupted ?
Thank.
This post has been answered by oradba on Nov 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2009
Added on Nov 12 2009
7 comments
991 views