Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Urgent! ORA-01578 :ORACLE data block corrupted (file # 7,block # 82979)

Urgent! ORA-01578 :ORACLE data block corrupted (file # 7,block # 82979)

From: Azhar Mahmood <azhar_at_iiu.edu.my>
Date: Thu, 3 Aug 2000 16:10:21 +0800
Message-Id: <10578.113693@fatcity.com>


Hi Listers

While running a PL/SQL procedure, I encountered the following error :

ORA-01578 :ORACLE data block corrupted (file # 7,block # 82979)
ORA-01110 : data file 7: '/oradisk05/oradata/uia/indek01.dbf'
ORA-06512 :  at "UIA.GEN_GRAD3", line 485
ORA-06512 :  at line 16

---

from the alert_log file :
Thu Aug 3 15:35:44 2000
  Current log# 8 seq# 5312 mem# 0: /oradisk03/oradata/uia/redo08.log LGWR: prodding the archiver
Thread 1 advanced to log sequence 5313
  Current log# 9 seq# 5313 mem# 0: /oradisk03/oradata/uia/redo09.log Thu Aug 3 15:35:54 2000
ARC0: received prod
ARC0: media recovery disabled
Thu Aug 3 15:36:05 2000
LGWR: prodding the archiver
Thread 1 advanced to log sequence 5314
  Current log# 10 seq# 5314 mem# 0: /oradisk03/oradata/uia/redo10.log Thu Aug 3 15:36:05 2000
ARC0: received prod
ARC0: media recovery disabled
***
Corrupt block relative dba: 0x01c14423 file=7. blocknum=82979. Bad header found during buffer read
Data in bad block - type:6. format:2. rdba:0x01c14413 last change scn:0x0000.0069cf55 seq:0x1 flg:0x02 consistancy value in tail 0xcf550601
check value in block header: 0x0, check value not calculated spare1:0x0, spare2:0x0, spare2:0x0



Please advise me what to do.... Received on Thu Aug 03 2000 - 03:10:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US