RE: On which asm disk is the corrupted block?

From: Amaral, Rui <>
Date: Thu, 21 Apr 2011 14:00:33 -0400
Message-ID: <1B861F1ABE40A84AA92AD585B20C558B270AD548AD_at_EX7T2-CV06.TDBFG.COM>

the following link has some examples on how to do this:

Rui Amaral
Database Administrator
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106

From: [] On Behalf Of dd yakkali Sent: Thursday, April 21, 2011 1:34 PM
Subject: On which asm disk is the corrupted block?

Oralce 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.


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

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to for instructions. AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au pour des instructions.

Received on Thu Apr 21 2011 - 13:00:33 CDT

Original text of this message