RE: Block corruption notes on MetaLink
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 11:10:38 -0600
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Gudmundur Josepsson
Sent: Wednesday, March 03, 2004 10:51 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
> Behalf Of Gudmundur Bjarni
> Josepsson
> Sent: Wednesday, March 03, 2004 7:48 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
?essi p?stur var sendur me? vefp?sti mi, http://www.mi.is
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
