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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
