ergent help: ora-27091 on system tablespace

From: chao zhu <chao_ping_cn_at_yahoo.com.cn>
Date: Sun, 02 Sep 2001 11:12:16 -0700
Message-ID: <F001.00380734.20010902112021@fatcity.com>

hi, gurus:
when i do a fulldatabase export, oracle error 27091 appeard:
. . exporting table MHNK
EXP-00008: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 1 (block # 13095)
ORA-01110: data file 1:
'/oracle/DEV/sapdata1/system_1/system.data1' ORA-27091: skgfqio: unable to queue I/O IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 13094

. exporting table                          MHNKA

EXP-00008: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 1 (block # 13095)
ORA-01110: data file 1:
'/oracle/DEV/sapdata1/system_1/system.data1' ORA-27091: skgfqio: unable to queue I/O
IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 13094
i checked the table, no record.
and no such 27091 message in alertsid.log.

i checked dba_extents, with block_id between 13094 and 13096, the table is a SAPR3 table:agr_1250? isn't a system table!

i run dbverify and it reported error message:

DEV_SVC:oradev 13> dbv file=system.data1 blocksize=8192

DBVERIFY: Release 8.1.7.0.0 - Production on Sun Sep 2 16:49:10 2001

(c) Copyright 2000 Oracle Corporation. All rights
reserved.

DBVERIFY - Verification starting : FILE = system.data1

DBV-00102: File I/O error on FILE (system.data1) during verification read operation (-2) so, it seems the datafile has corrupted, and i do not know when it corrupted.
  Shall i just recreate the tables affected, or restore the database.

If restore, when to begin? I do not know when it corrupted, since no error message in alertsid.log?

And now i cannot backup the corrupted datafile, neither through cp or dd.It always abort at the middle of the datafile.

thanks.

---

Do You Yahoo!? 登录免费雅虎电邮! http://mail.yahoo.com.cn

<font color=#6666FF>无聊？郁闷？高兴？没理由？都来聊天吧！</font>—— 雅虎全新聊天室! http://cn.chat.yahoo.com/c/roomlist.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?gb2312?q?chao=20zhu?=
  INET: chao_ping_cn_at_yahoo.com.cn

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Sun Sep 02 2001 - 13:12:16 CDT