Re: Corrupt block relative dba

Check the file size (get the file name from v$datafile for file#=8, then look at its directory.)

I have had files get corrupted (strangely enough also on AIX) on two occasions.In the most recent case, a restore from backup was 4K too small. On the other occasion, the backup had been compressed, but was not fully restored on uncompress, but showed the same size. (The uncompress utility had not restored inodes filled with x00, which is unused tablespace.)

We had to restore from a backup and roll forward.

One other way, I think I received this message was with raw devices, where the device had gone offline so the logical pointer was pointing to nothing, so the block was interpreted as bad/empty. We just mounted the device and everything trucked on down the road.

Come to think of it, we also got/get this message when a restore from tape has gone bad, leaving file directory entries but no data. In these last two cases, we just copied the file back again and everything was ok, so these last were inconveniences, not problems. The first two, requiring recovery, were problems.

"Anthony Hollis" <ahollis_at_faritec.co.za> wrote in message news:<995023716.429873_at_nntp01.uskonet.com>...
> Hi,
> I am the AIX CE for a customer with the following error in the oracle logs.
> They are Using AIX 4.3.3 ML08, there is no error(s)in the AIX error log
> pertaining to disk; bad blocks. They have received this error before. The
> DBA assures me that all the oracle Patches/Fixes have been Installed/Applied
> etc. The machine is a F50 with SSA disks. The version of oracle is 8.0.5
> Thanks in advance.
> Cheers
>
> This is the error
> -------------------->
>
> Corrupt block relative dba: 0x0200618a file=8. blocknum=24970.
> Bad header found during buffer read
> Data in bad block - type:6. format:2. rdba:0x02817ae7
> last change scn:0x0000.01425b8d seq:0x1 flg:0x02
> consistancy value in tail 0x5b8d0601
> check value in block header: 0x0, check value not calculated
> spare1:0x0, spare2:0x0, spare2:0x0
> Reread of rdba=200618a file=8. blocknum=24970. found same corupted data
> -------------------->
Received on Sat Jul 21 2001 - 16:37:14 CDT