DBVERIFY detected corrupted blocks

[Former Member]

Hello Gurus,

I am facing This Error In My R-3 Server, Can Somebody Define this Error, What is a Cause And What is The Rectification of This Error ?

Error Description

1. BR0398E DBVERIFY detected corrupted blocks in /oracle/DBS/sapdata88/btabi_114/btabi.data114

2. BR0398E DBVERIFY detected corrupted blocks in /oracle/DBS/sapdata22/btabd_38/btabd.data38

Waiting For An Prompt Reply

[Former Member]

Hello,

I do not understand why you are asked for the BR* tools version or the oracle one.

Resume -> you <b><u>have</u></b> corrupted blocks on your database.

It looks like on an index datafile ( if you are lucky it is an index and it could be rebiuld ) and on a "data" datafile ( if you are lucky is on free space )

Take a look at note <a href="http://service.sap.com/sap/support/notes/365481">365481</a>

and to the SDN blog:

<a href="/people/lars.breddemann/blog/2007/03/21/i-can-repair-your-corrupt-database">I can repair your corrupt database!</a>

If one of the objects affected is a table and you do not have a good backup, probably you will lose some data.

[Former Member]

i found one one which tells about the version of your BR* (brbackup) utility, but this is for raw devices.

Cheers,

-Sunil

[Former Member]

what is the version of BR* you are using? and also oracle versoin?

Cheers,

-Sunil