cancel
Showing results for 
Search instead for 
Did you mean: 

Corrupted LOBSEGMENT

Former Member
0 Kudos

Hello,

the DBVERIFY has detected an corrupted block in our Oracle DB:

BR0395I Verifying /oracle/PSM/sapdata2/sr3_9/sr3.data9 using DBVERIFY...

BR0278W Command output of '/oracle/PSM/102_64/bin/dbv file=/oracle/PSM/sapdata3/sr3700_4/sr3700.data4 blocksize=8192':

DBVERIFY: Release 10.2.0.2.0 - Production on Sat Feb 21 23:00:18 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle/PSM/sapdata3/sr3700_4/sr3700.data4

Page 67017 is marked corrupt

Corrupt block relative dba: 0x044105c9 (file 17, block 67017)

Bad header found during dbv:

Data in bad block:

type: 65 format: 2 rdba: 0x54434152

last change scn: 0x3d4c.504d495f seq: 0x3d flg: 0x3d

spare1: 0x53 spare2: 0x54 spare3: 0x433d

consistency value in tail: 0xc3c92801

check value in block header: 0x3d3d

computed block checksum: 0xde9a

DBVERIFY - Verification complete

Total Pages Examined : 771840

Total Pages Processed (Data) : 197695

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 310391

Total Pages Failing (Index): 0

Total Pages Processed (Other): 241245

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 22508

Total Pages Marked Corrupt : 1

Total Pages Influx : 0

Highest block SCN : 59372008 (0.59372008)

BR0398E DBVERIFY detected corrupted blocks in /oracle/PSM/sapdata3/sr3700_4/sr3700.data4

BR0280I BRBACKUP time stamp: 2009-02-21 23.06.39

BR0063I 13 of 21 files processed - 26260.102 MB of 63440.164 MB done

BR0204I Percentage done: 41.39%, estimated end time: 23:15

Now I try to identify if it is a table or an index:

SQL> SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE

2 FROM DBA_EXTENTS WHERE FILE_ID = 17 AND 67017

3 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS -1;

OWNER

-


SEGMENT_NAME

-


SEGMENT_TYPE

-


SAPSR3

SYS_LOB0000020043C00004$$

LOBSEGMENT

SQL> SQL>

But the result is an affected LOBSEGMENT. How can I fix this problem ?

Thanks and Best Regards

Carsten

Edited by: Carsten Leidner on Feb 27, 2009 5:18 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

Hi Carsten,

you will likely need a good backup to resolve this.

To find out, which column in which table is affected, simply run


select * from dba_lobs where segment_name='SYS_LOB0000020043C00004$$';

After that you may try to export the affected table.

You may be lucky to find that the full table is still exportable.

Otherwise - open a SAP support message to get some help on how to proceed with the affected table.

(e.g. it could be that a table like REPOLOAD is affected. In this case it would be possible to completely rebuild all data in the table.)

regards,

Lars

former_member204746
Active Contributor
0 Kudos

SELECT owner, table_name, column_name

FROM dba_lobs

WHERE segment_name = 'SYS_LOB0000020043C00004$$';

you will find table name affected and decide from that point on what to do.