On which asm disk is the corrupted block?

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Thu, 21 Apr 2011 10:33:53 -0700
Message-ID: <BANLkTi=iAXf28+0JU3cxJd=jtakTDTT8sw_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 21 2011 - 12:33:53 CDT

Original text of this message