| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Block corruption notes on MetaLink
Gudmundur
Glad to hear you have the corruption quarantined for now. My instinctive reaction would be to keep the corruption as far away from the existing objects as possible. If you don't need the contents of those objects, I would recreate them fresh in your new tablespace. Then blast the existing tablespace into the bit bucket. Then turn on all the corruption checking I could. Consider exporting all schema objects each night. However, my experience with 9i versions below 9.2.0.4 is that export itself can cause corruption. Specifically if the system tablespace is exported.
Make all haste in getting to 9.2.0.4.
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 12:34 PM
To: oracle-l_at_freelists.org
Subject: RE: Block corruption notes on MetaLink
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
-- 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 - 13:21:25 CST
 |
 |