Datafile error

[Former Member]

Due to some issues in the system for a particular datafile, the updates were failing. When DBVERIFY was ran in online mode using BRTOOLS

three files showed the error as mentioned below -

DBV-00600: Fatal Error - [25] [-1082424288] [1941] [149536] BR0280I BRBACKUP time stamp: 2012-10-14 23.53.26 BR0279E Return code from '/oracle/ARD/102_64/bin/dbvfile=/oracle/ARD/sapdata2/ard701_2/ard701.data2 blocksize=8192': 3

The files for which this occurred =

file=/oracle/ARD/sapdata4/ard_9/ard.data9

file=/oracle/ARD/sapdata4/ard_8/ard.data8

file=/oracle/ARD/sapdata2/ard701_2/ard701.data2

Can you please look into this and let us know?

Thanks & Regards,

[former_member289242 · Accepted solution]

Hello Deepthi,

Please do a full consistency check on your database to find corrupted
blocks as per attached Note 23345. You need to perform a database
consistency via rman validate as well.

You need to identify the object that belongs to the corrupt blocks refer
note 365481.

Use the following command to determine the objects.

select segment_name, segment_type, block_id, blocks from dba_extents
sewhere (<corrupted block> between block_id and (block_id + blocks - 1))
and file_id = <DB verification report>;

For index corruption, you can drop and recreate the index.
For table corruption, please perform the restore and recovery on the
effected datafile if you have valid backup.

Please proceed as per note 365481 to handle the block corruption issue.

Regards,

Gunjan