RE: Urgent! ORA-01578 :ORACLE data block corrupted (file # 7,bloc

From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <DBA.Gurgaon_at_geind.GE.com>
Date: Thu, 3 Aug 2000 15:58:03 +0530
Message-Id: <10578.113701@fatcity.com>

Try to restore the segment containing the given data block. This may involve dropping the segment and recreating it. If there is a trace file, report the messages recorded in it to customer support.

Vikas

-----Original Message-----

From: Azhar Mahmood [mailto:azhar_at_iiu.edu.my] Sent: Thursday, August 03, 2000 2:46 PM
To: Multiple recipients of list ORACLE-L Subject: Urgent! ORA-01578 :ORACLE data block corrupted (file # 7,block # 82979)

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

--

Author: Azhar Mahmood
  INET: azhar_at_iiu.edu.my

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 03 2000 - 05:28:03 CDT