Bad Blocks ORA_01578

From: Nina Boss <nina.boss_at_ccmail.adp.wisc.edu>
Date: 1996/05/15
Message-ID: <4ndjnh$1s0o_at_news.doit.wisc.edu>#1/1

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 Received on Wed May 15 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Beatrice Dupont: "US-FL-s104-Jr. DBA - Orlando Oracle"
Previous message: Muhammad A. Malik: "Re: Can SET_BLOCK_PROPERTY turn off sorting?"
Maybe reply: Bob Manieri: "Re: Bad Blocks ORA_01578"
Maybe reply: Eric Evans: "Re: Bad Blocks ORA_01578"
Maybe reply: Gonzalo Gili I: "Re: Bad Blocks ORA_01578"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message