Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Block Corrupted

Status
Not open for further replies.

oshkhaine

Programmer
Sep 19, 2002
18
BD
Hi everybody , I do not know whether AIX has anything to do with this problem. But I am sure there are some expert here in this forum who can solve my problem. Here Oracle 7.3.4 running on AIX in IBM RS6000. The f0llowing error message I got yesterday. I hope someone can help me in this matter
"ORACLE data block corrupted (file #24 block #33931) data file 24:'/d05/oradata/ctglive/data/ebcd11.dbf' at "SYS.DBMS_UTILITY", LINE 232

Thanks.

 
Hi,

This looks like an ORACLE DB corruption issue.I would look at oracle forum.

However,prior to this - you can check for filesystem/disk/scsi errors oriented to the specific disk/filesystem wher ORACLE DB remains.Just run:

errpt |grep -E "scsi|hdisk" "Long live king Moshiach !"
h
 
I have got this error message. Now what shall I do

# errpt |grep -E "scsi|hdisk"
0BA49C99 1113000802 T H scsi0 SCSI BUS ERROR
0BA49C99 0912165502 T H scsi0 SCSI BUS ERROR
0BA49C99 0905000602 T H scsi0 SCSI BUS ERROR
0BA49C99 0819000802 T H scsi0 SCSI BUS ERROR
1581762B 0714120202 T H hdisk4 DISK OPERATION ERROR
0BA49C99 0709170302 T H scsi0 SCSI BUS ERROR
0BA49C99 0625072602 T H scsi0 SCSI BUS ERROR
0BA49C99 0603070402 T H scsi0 SCSI BUS ERROR
 
Hi,

Assuming hdisk4 is the one where you have your ORACLE DB (check using &quot;lspv&quot; and &quot;lsvg -l <vgname>&quot;) you have to replace the faulty disk.
Or it can be a scsi probem - cable,termination,HBA.

If it's a disk problem - refer to the following for replacemnt procedure (assume you have a good backup ..):
&quot;Long live king Moshiach !&quot;
h
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top