Re: Red Hat 2.1, Oracle 9.2.0.5 and 25GB file block corruption on
HP 2005-01-27 - By Tim Gorman
April,
After all, EXP will drop dead on only the first corrupt block within the
high-water mark of tables; it won't check indexes.
Some better alternatives:
1) If error messages (or the trace files accompanying the ORA-00600 (See ORA-00600.ora-code.com))
displayed actual block addresses (either FILE#/BLOCK# or DBA), then you can
use the DBMS_REPAIR.CHECK_OBJECT procedure to verify, after obtaining the
name of the segment by querying DBA_EXTENTS...
2) ALTER SYSTEM DUMP DATAFILE [ file-id | 'file-name' ] [ BLOCK block-id |
BLOCK MIN min-block-id BLOCK MAX max-block-id ] can help as well? It
produces a trace file in the USER_DUMP_DEST, and usually if the block is
corrupted, the dump will say exactly that...
3) RMAN "backup validate" command performs a "false backup" (i.e. just reads
datafiles, doesn't write to backup media). This is the "EXP FULL=Y
FILE=/dev/null" command done the right way...
Hope this helps...
-Tim
on 1/27/05 3:04 PM, aj wells at awellsdba@(protected) wrote:
> 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 (See ORA-00600.ora-code.com): 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
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
|
|
