hi, bardeen:
Thanks for your reply.
The database has a valid backup, and after the
backup, no further operation is done.So, what i shall
do is only to restore that full backup and it is OK.
Now i wantto know why this happen, and if the disk
is error itself.For Oracle doesnot know it: without
any relevant message in alert file.
thank u very much.
- "A. Bardeen" <abardeen1_at_yahoo.com> 的正文：>
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
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 Mon Sep 03 2001 - 23:53:56 CDT
