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

In my experience this usually occurs on indexes.

You can determine which object has the corrupt block with the script below.

If it's an index, just drop an rebuild it. You may want to pursue why you have a corrupt block. Work with the SA to check the system logs.

Jared

• ora_1578.sql
• use args from ORA-1578 errors to find
• file and segment generating the error

col cfileid new_value ufileid noprint
col cblockid new_value ublockid noprint

prompt File ID:
set term off feed off
select '&1' cfileid from dual;

set feed on term on
prompt Block ID:
set term off feed off
select '&2' cblockid from dual;
set feed on term on

#define ufileid=8
#define ublockid=129601

select file_name "FILE WITH CORRUPT BLOCK" from dba_data_files
where file_id = &ufileid
/

col segment_name format a30
col segment_type format a15

select segment_name, segment_type
from dba_extents
where file_id = &ufileid and &ublockid between block_id and block_id + blocks - 1
/

undef 1 2

On Thu, 3 Aug 2000, Azhar Mahmood wrote:

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

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon Received on Fri Aug 04 2000 - 13:14:21 CDT