Corruption in the system datafile takes special handling so if you haven't already done so I highly recommend logging a tar with support. If you are unable to even cp or dd the file then you most likely have a problem with the file at the OS level and you need to get that issue resolved. As to your recovery situations, it depends on when your last backup was taken and if the db is in archivelog mode. The best method if the db is in archivelog mode is to identify a backup containing a clean version of the datafile (i.e. one in which dbv doesn't report any errors), restore that datafile from backup, and recover it. Since this is a datafile belonging to the system tablespace you will need to shutdown the db and do this from a mount stage. I would highly recommend doing a full db export for safekeeping in the event that there are any problems with your backups. HTH, -- Anita --- chao zhu <[EMAIL PROTECTED]> wrote: > 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>?D???Æ??????û-?????4D????</font>???? > > ?????D??! > 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). __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
