| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Block Corrupted
Steve Raftery wrote:
> Thanks in Advance!
>
> I am currently having trouble with one of the segments in my database.
> When I select count(*) from tablename I recieve the following error.
>
> ERROR:
> ORA-01578: ORACLE data block corrupted (file # 11, block # 901)
> ORA-01110: data file 11: '/oracle7/dbs/datafile01.dbf'
>
ORA-1578 will produce a trace file. In the trace file there will be moreinformation as to what type of corruption it is. This may be an Oracle
bug, an OS issue or something went wrong with the drive. Usually seeing a page full of zeros indicates an OS or striping issue. Contact Support with trace file for more details on your case. You can also try setting event 10231 which will skip corrupt blocks on full table scans, then reissue the select or use export to recreate that table.
> I have checked the file on disk and it seems to be okay. There is no
> error in the file system block so I must assume it is an error in the
> oracle block. I can still select rows from the table, but cannot access
> all of them, the ones I cannot I assume are in the corrupted block.
>
> I would appreciate any information that would help me clear up this
> problem. Any tools available, such as scripts or outside vendor tools?
> --
> Steve Raftery
>
> Webvision
> 19950 Mariner Avenue
> Torrance, CA 90503
> www.webvision.com
--
__ _ _ __ _ _ _ _ ___ ______________________________ (( /\\ /\\ ||) |\V/| /\\ /\\ >/ Principal Performance Engineer_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Digital SBU
////////////////// Drop x's in email (spam) //////////////////////Received on Fri Jul 10 1998 - 16:18:03 CDT
 |
 |