RE: corrupted block

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 27 Feb 2003 06:34:04 -0800
Message-ID: <F001.0055B624.20030227063404@fatcity.com>

Rachel,

  Were you running the validate command on your backups?   It would be interesting to see if that wasn't cutting   the mustard either.

Brian Spears   

-----Original Message-----
Sent: Wednesday, February 26, 2003 9:59 PM To: Multiple recipients of list ORACLE-L

I wish it was someone trying to do that. This is what I get after I restore a good rman backup to a bad disk.

I have hundreds of these messages (or similar ones) in that alert log file.... sigh. My data center operations people are insisting that it CAN'T be hardware problems.

Of course, we took the EXACT SAME BACKUP, restored it to another filesystem and have NO corruption in the database. But it can't possibly be hardware problems. It's just Oracle playing games with my mind.

• Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
  >
  > That's the cutest corruption I've ever seen -
  > it looks like someone has been practising
  > there C programming with "How to write direct
  > to an Oracle data file without using Oracle"
  >
  > Regards
  >
  > Jonathan Lewis
  > http://www.jlcomp.demon.co.uk
  >
  > Coming soon one-day tutorials:
  > Cost Based Optimisation
  > Trouble-shooting and Tuning
  > Indexing Strategies
  > (see http://www.jlcomp.demon.co.uk/tutorial.html )
  >
  > ____UK_______March 19th
  > ____USA_(FL)_May 2nd
  >
  >
  > Next Seminar dates:
  > (see http://www.jlcomp.demon.co.uk/seminar.html )
  >
  > ____USA_(CA, TX)_August
  >
  >
  > The Co-operative Oracle Users' FAQ
  > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
  >
  >
  > ----- Original Message -----
  > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
  > Sent: 26 February 2003 19:14
  >
  >
  > > Here you go:
  > >
  > > ***
  > > Corrupt block relative dba: 0x0240000a (file 9, block 10)
  > > Bad header found during buffer read
  > > Data in bad block -
  > > type: 32 format: 0 rdba: 0x20202020
  > > last change scn: 0x2020.20202020 seq: 0x20 flg: 0x20
  > > consistency value in tail: 0x20202020
  > > check value in block header: 0x2020, block checksum disabled
  > > spare1: 0x20, spare2: 0x20, spare3: 0x2020
  > > ***
  > > Reread of rdba: 0x0240000a (file 9, block 10) found same corrupted
  > data
  > >
  > >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: Jonathan Lewis
  > INET: jonathan_at_jlcomp.demon.co.uk
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  >
  

  ---

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Spears, Brian
  INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 27 2003 - 08:34:04 CST