RE: On which asm disk is the corrupted block?
- From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
- To: "'dd.yakkali@xxxxxxxxx'" <dd.yakkali@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2011 14:00:33 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of dd yakkali
Sent: Thursday, April 21, 2011 1:34 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
