to find which segment it is you can use:
SELECT SEGMENT_NAME, SEGMENT_TYPE FROM DBA_EXTENTS=20
WHERE FILE_ID =3D 8 aND 12866 betWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - =
1;=20
and if it is index you can try to drop+create it again. But in your =
case
call support very soon.
Ivo Libal
> -----Urspr=FCngliche Nachricht-----
> Von: Allan Robertson [SMTP:allan.robertson_at_morse.com]
> Gesendet am: Donnerstag, 3. August 2000 13:14
> An: Multiple recipients of list ORACLE-L
> Betreff: RE: Urgent! ORA-01578 :ORACLE data block corrupted (file #
> 7,block # 82979)
>=20
> Raise a tar with Oracle v. quickly .
> Also there is a good article on Metalink on isolating the problem.
>=20
> This is either a corrupted block in your data file(requires recovery) =
or
> an
> initimate shared memory problem.
>=20
> Allan
>=20
>=20
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Azhar
> > Mahmood
> > Sent: Thursday, August 03, 2000 10:16 AM
> > 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=3D7. blocknum=3D82979.
> > 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).
> >
>=20
> --=20
> Author: Allan Robertson
> INET: allan.robertson_at_morse.com
>=20
> 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
Received on Thu Aug 03 2000 - 06:31:13 CDT
