RE: Red Hat 2.1, Oracle 9.2.0.5 and 25GB file block corruption on HP

  • From: "Hollis, Les" <Les.Hollis@xxxxxx>
  • To: <awellsdba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 27 Jan 2005 16:23:26 -0600

This export Oracle had you start...I am hoping they told you to export
to /dev/null


If not, that is where you need to send the export ..It will speed
through must faster and will then let you know if there is corruption in
the file.

Also, have you tried dbv  (DBVerify)????




-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of aj wells
Sent: Thursday, January 27, 2005 4:05 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Red Hat 2.1, Oracle 9.2.0.5 and 25GB file block corruption on
HP

Okay... not that that is out of the way...

We have a multi TB databae (one of several) that has many 25GB files
(since it seems that is the biggest file we can make... ) and we have
several file systems.  "we" just created two new file systems that are
600+ GB each across several disks (0+1).

When we allocated new files on the first of these file systems, we got
block corruption... (ORA-00600: INTERNAL ERROR CODE, ARGUMENTS:
[25012], [27]) on several of the files.

HP says not hardware, RH says either Oracle or Hardware and Oracle
says it is OS or hardware.

Anyone else seen anything vaguely resembling this... it is becoming a
big giant Charlie Foxtrot and no one is of much help (although Oracle
did have us start an export 13 hours ago on the tablespace and it is
now nearly half done... that will tell us if the two extents in the
only file left showing corruption is actually corrupt or only
pretending to be... )

thanks
aj
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: