Re: Oracle Block Corrupted

From: MMK Productions <nospammmkprod_at_bellatlantic.net>
Date: Fri, 10 Jul 1998 00:19:55 -0400
Message-ID: <6o44vj$1d0@world6.bellatlantic.net>

I have experience with this on AIX 3.2.5 and Oracle 7.1.6. We found it was a non-IBM drive and it was non-repeatable. However, once, it was a real bad disk.

Solutions:

1) segment using that block was an index - re-create index
2) seg = RBS, same
3) seg = table, a) use an Oracle Support PL/SQL script to try to get most of

the data back, b) go back to a backup [I chose 'b']

Always have a data file report on hand listing the datafiles and their 'file#' value listed. Sometimes, the # is all you get in the error msg.

Steve Raftery wrote in message <35A56341.2781_at_webvision.com>...
>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'
>
>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
Received on Thu Jul 09 1998 - 23:19:55 CDT