Re: Bad Blocks ORA_01578
Date: 1996/05/20
Message-ID: <4nqu2i$f4l_at_news.iag.net>#1/1
Nina Boss <nina.boss_at_ccmail.adp.wisc.edu> wrote:
>We gave two Oracle servers. Version 7.1.6 and Version 7.2.2.4., on an RS/6000
>with AIX v4.2. The disks are FWD by Seagate. We use the servers mainly in
>client/server mode. With tools ranging from BRIO query to Oracle Card. Both
>servers are mainly datawarehouse applications.
>Our problem, we have gotten Oracle BAD BLOCK erros over and over again. We move the
>tables and indexes all over the disks (each server has 12 of them), and drop and
>recreate them in many different tablespaces. STill we get these errors.
>The kicker is, many times the file number and block number reported doesn't have a
>bad block. We know because we use Oracle's method for scanning a block by it's HEX
>record id.
>Does anyone else see this problem? ORACLE Support people seem as baffled as we are.
>Thanks for any help!
>Nina Boss
>University of Wisconsin-Madison
Nina:
See if you have the init.ora paramater set for using async_io to true. I seem to remeber a AIX bug on async I/O. If unsetting it works for you I would contact AIX for the PTF . Received on Mon May 20 1996 - 00:00:00 CEST