Hi,

I got the follwing error message:
"Error 2578 (bdb_errno 520) on tttxt002800 in SELECT"

I checked ORACLE/BAAN logs and it seems that I need to drop an index segment and recreate it.

This can be done from ORACLE or I need to use reorganize table session from baan?

Below is ora log (part of it):
Corrupt block relative dba: 0x0702b8ff file=28. blocknum=178431.
Bad header found during buffer read
Data in bad block - type:8. format:2. rdba:0x00c03bcc
last change scn:0x0000.08338df2 seq:0x1 flg:0x08
consistancy value in tail 0x8df20801
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0
Reread of rdba=702b8ff file=28. blocknum=178431. found same corupted data
*** 2002.10.03.07.09.05.000
ksedmp: internal or fatal error
ORA-01578: ORACLE data block corrupted (file # 28, block # 178431)
ORA-01110: data file 28: '/u06/oradata/baanIV/idx10baanIV.dbf'

Alert message (part of it; there are more entries loocking the same):
Corrupt block relative dba: 0x0702b8ff file=28. blocknum=178431.
Bad header found during buffer read
Data in bad block - type:8. format:2. rdba:0x00c03bcc
last change scn:0x0000.08338df2 seq:0x1 flg:0x08
consistancy value in tail 0x8df20801
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

And also a part of baan log:
******* S T A R T of Log message *******
102-10-03[09:33:30]ventes1: Log message called from /port.6.1c.02.02/vobs/tt/mir/mir/bdb_fun.c: #908 keyword: DB error
102-10-03[09:33:30]ventes1: Pid 65308 Uid 377 Euid 377 Gid 125 Egid 125
102-10-03[09:33:30]ventes1: user_type S language r user_name ventes1 tty ote locale ISO88591/NULL
102-10-03[09:33:30]ventes1: Errno 0 bdb_errno 520 (Error during buffered updates)
102-10-03[09:33:30]ventes1: Log_mesg: Error 2578 (bdb_errno 520) on tttxt002801 in SELECT
102-10-03[09:33:30]ventes1: ********** E N D of Log message **********

Thank you.

The easiest way is to use Baan Tools. Did you check for HW problems on your disks? A good idea is maybe also to run the Oracle tool 'dbverify' to see if anymore problems may exist.

Patvdv, thank you very much for your answer.
What do you mean by "easiest way"? I mean it's, easier AND safer? You know, a lot of people is watching your back in such cases.;)

Thnak you again

Hi Bogdan,

Yes I would say easier and safer.

Thanks a lot Pat; I'll start recovering.