On which asm disk is the corrupted block?

  • From: dd yakkali <dd.yakkali@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 21 Apr 2011 10:33:53 -0700

Oralce 11.1.0.7 ASM & DB RAC on RHEL5

We see corruption on a table and have the file id and block id. I am trying
to find out which asm disk that block is on. We see 1 corrupted block in
bunch of few of the tablespaces.

I need to give the information to the hardware guys regarding which physical
disk this block is on. I am wondering is there any way to pull that
information.

Any help is greatly appreciated.

thanks
Deen

age 2088137 is marked corrupt
Corrupt block relative dba: 0x001fdcc9 (file 1024, block 2088137)
Bad header found during dbv:
Data in bad block:
 type: 11 format: 2 rdba: 0x00000001
 last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x00000b01
 check value in block header: 0x7499
 computed block checksum: 0x0

Other related posts: