Re: corrupt block

DB Verify(dbv an executable in $ORACLE_HOME/bin) may give you some more direction. dbv may be run at anytime, whether the database is up or down. If it finds corruption, it should give the block number. You then could determine what the object is, then take appropriate action. See Oracle's Note:35512.1 on DB Verify.

EP

goldensurfer_at_gmx.de (Ralf Zwanziger) wrote in message news:<3b246695.170537850_at_news.fth.sbs.de>...
> Hi,
> we've got an entry in the alertXXX.log file every day, saying:
>
> ***
> Corrupt block relative dba: 0x06400c09 (file 25, block 3081)
> Bad header found during buffer read
> Data in bad block -
> type: 16 format: 2 rdba: 0x06001609
> last change scn: 0x0000.0b32fdb4 seq: 0x1 flg: 0x00
> consistency value in tail: 0xfdb41001
> check value in block header: 0x0, block checksum disabled
> spare1: 0x0, spare2: 0x0, spare3: 0x0
> ***
>
> Is there a way to find out more information on corrupt datafiles?
> Is it possible to repair the datafile?
>
> Bye,
> Ralf
Received on Mon Jun 11 2001 - 07:58:58 CDT