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 <chao_ping_cn_at_yahoo.com.cn> 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: 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).
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: abardeen1_at_yahoo.com
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 Mon Sep 03 2001 - 07:43:06 CDT