Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Block corruption notes on MetaLink

RE: Block corruption notes on MetaLink

From: Gudmundur Josepsson <gbj_at_index.is>
Date: Wed, 3 Mar 2004 18:33:35 GMT
Message-Id: <200403031833.i23IXZ312907@smtp.mmedia.is>


Dennis,

We've already located all the objects affected by the block corruptions. Fortunately, they all seem to be in indexes and summary tables which we can recreate. All in the same tablespace, all on the same disk. db_block_checksum is set to true.

The plan is to create a new tablespace on a new disk and move all the uncorrupted objects to the new tablespace and recreate indexes and summary tables. Is it enough to move with 'alter table move' or do we need to go for exp/imp?

Database version is 9.0.1.4. Maybe they'll use this opportunity to upgrade :-)

Thanks,
Gudmundur

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



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 - 12:32:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US