Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Block corruption notes on MetaLink
Gudmundur
I would first locate the datafile, using the file number listed in your error message. This will map to a tablespace. Then see if you can export the objects that are in this tablespace. If one errors out, you will have a handle on the problem. On Metalink, Note 131856.1 is an index to the various resources on corruption in Oracle. Consider setting the db_block_checksum with both an alter system and then in your init.ora file to ensure the corruption is not spreading. Once you have more information, this list can probably offer more assistance. Good luck.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Gudmundur Josepsson
Sent: Wednesday, March 03, 2004 10:51 AM
To: oracle-l_at_freelists.org
Subject: RE: Block corruption notes on MetaLink
Dennis,
We're using RMAN to back up. The error message we get is:
***
Corrupt block relative dba: 0x07c07e10 (file 31, block 32272)
Bad check value found during backing up datafile
Data in bad block -
type: 27 format: 2 rdba: 0x07c07e10
last change scn: 0x0000.da925d20 seq: 0x2 flg: 0x04
consistency value in tail: 0x5d201b02
check value in block header: 0xe344, computed block checksum: 0x400
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=32272, file=E:\ORADATA\AGR53\AGRSTATIC07.DBF. found same
corrupt data
I just discovered that we're also receiving this during non-backup operations:
***
Corrupt block relative dba: 0x0b401620 (file 45, block 5664)
Bad check value found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0b401620
last change scn: 0x0000.daa7b068 seq: 0x2 flg: 0x04
consistency value in tail: 0xb0680602
check value in block header: 0x1675, computed block checksum: 0x400
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0b401620 (file 45, block 5664) found same corrupted data
Gudmundur
> Gudundur - How are you backing up the datafile? What is producing the
error
> - Oracle? Do you receive an error message? If so, please post.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On
> Behalf Of Gudmundur Bjarni
> Josepsson
> Sent: Wednesday, March 03, 2004 7:48 AM
> To: oracle-l_at_freelists.org
> Subject: Block corruption notes on MetaLink
>
>
> List,
>
> We're receiving:
>
> Bad check value found during backing up datafile
> Data in bad block -
>
> in the alert log. I can't find any notes about this exact error on
> MetaLink. Any pointers?
>
> Thanks,
> Gudmundur
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
?essi p?stur var sendur me? vefp?sti mi, http://www.mi.is
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Mar 03 2004 - 11:13:10 CST