RE: On which asm disk is the corrupted block?

From: Amaral, Rui <Rui.Amaral_at_tdsecurities.com>
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:

https://twiki.cern.ch/twiki/bin/view/PDBService/ASM_Internals

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

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dd yakkali Sent: Thursday, April 21, 2011 1:34 PM
To: oracle-l_at_freelists.org
Subject: On which asm disk is the corrupted block?

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

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal 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 www.td.com/francais/avis_juridique pour des instructions.

--
http://www.freelists.org/webpage/oracle-l

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