RE: Block corruption notes on MetaLink
- From: Gudmundur Josepsson <gbj@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 18:33:35 GMT
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@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
> -----------------------------------------------------------------
Þ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
-----------------------------------------------------------------
Other related posts:
