Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unix question : how to verify disk corruption ?

RE: Unix question : how to verify disk corruption ?

From: Rivaldi Bahar <rivaldi_bahar_at_hotmail.com>
Date: Tue, 16 Jan 2001 00:43:50 +0700
Message-Id: <10742.126693@fatcity.com>


Use "iostat -en 5 10"
Here is from manual page :
-e : Display device error summary statistics. The

     total   errors,   hard  errors,  soft  errors  and
     transport errors are displayed.

Tx,
Rivaldi Bahar

> > -----Mensaje original-----
> > De: paquette stephane [SMTP:stephane_paquette_at_yahoo.com]
> > Enviado el: lunes 15 de enero de 2001 15:35
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Unix question : how to verify disk corruption ?
> >
> > Hi,
> >
> > This is linked to my ora-600 problem.
> > Of course, the SA is not here today.
> >
> > How do I verify that the disks are not corrupted ?
> > This is a Sun E450 with Solaris 5.7.
> > Disks are from Sun , 18g disks. Nothing fancy.
> > We're using Veritas Volume Manager
> >
> > TIA
> >
> > --- "Trassens, Christian" <CTrassens_at_uni2.es> a
> > écrit : > Sorry, I've read it again and I have a
> > doubt. How
> > > could it be the uet$
> > > corrupted ?. Or did you transform an dictionary to
> > > local with
> > > dbms_space_admin ?.
> > >
> > > Regards.
> > >
> > > > -----Mensaje original-----
> > > > De: Trassens, Christian [SMTP:CTrassens_at_uni2.es]
> > > > Enviado el: lunes 15 de enero de 2001 13:15
> > > > Para: Multiple recipients of list ORACLE-L
> > > > Asunto: RE: ORA-600 with smon crashing the db as
> > > soon it is started
> > > >
> > > > So, let us know the workaround.....if it had one.
> > > >
> > > > > -----Mensaje original-----
> > > > > De: paquette stephane
> > > [SMTP:stephane_paquette_at_yahoo.com]
> > > > > Enviado el: lunes 15 de enero de 2001 12:56
> > > > > Para: Multiple recipients of list ORACLE-L
> > > > > Asunto: RE: ORA-600 with smon crashing the db as
> > > soon it is started
> > > > >
> > > > > Unfortunately, the stack trace from my problem
> > > is
> > > > > different from the stack trace of bug 1397075
> > > (and I
> > > > > did not drop any locally managed tbs).
> > > > >
> > > > > According to Oracle, it seems to be a corruption
> > > in
> > > > > uet$ (all my tbs are locally managed except
> > > system)
> > > > >
> > > > > Oracle will open a new bug. (Do I have a t-shirt
> > > ?)
> > > > >
> > > > > What bothers me is that it can happen again
> > > since no
> > > > > correction have been applied.
> > > > >
> > > > >
> > > > >
> > > > > --- "Trassens, Christian" <CTrassens_at_uni2.es> a
> > > > > écrit : > Hi,
> > > > > >
> > > > > > You've received the symptons of the bug
> > > 1397075.
> > > > > > Have you dropped a read
> > > > > > only tablespace locally managed ??.
> > > > > >
> > > > > > Startup mount the database and issue and alter
> > > > > > database datafile '......'
> > > > > > offline drop; for each datafile of the tblsp
> > > that
> > > > > > you intended to drop. And
> > > > > > then you can open the database and drop the
> > > > > > tablespace with option including
> > > > > > contents;
> > > > > >
> > > > > > Regards.
> > > > > >
> > > > > > > -----Mensaje original-----
> > > > > > > De: paquette stephane
> > > > > > [SMTP:stephane_paquette_at_yahoo.com]
> > > > > > > Enviado el: lunes 15 de enero de 2001 11:20
> > > > > > > Para: Multiple recipients of list ORACLE-L
> > > > > > > Asunto: ORA-600 with smon crashing the db as
> > > soon
> > > > > > it is started
> > > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > On Solaris 5.7/Oracle 816 (64 bit), I have a
> > > > > > server
> > > > > > > with 3 identical databases. 2 of them have
> > > crashed
> > > > > > > late friday night and I'm not able to start
> > > them.
> > > > > > >
> > > > > > > I started them but just after the db are
> > > opened,
> > > > > > smon
> > > > > > > crash them with have ORA-600 [kcbgcur_9].
> > > > > > >
> > > > > > > Since there is an ORA-600, I've called
> > > Oracle
> > > > > > support.
> > > > > > >
> > > > > > > If anyone had this one, I'd be glad to hear
> > > it.
> > > > > > >
> > > > > > > TIA
> > > > > > >
> > > > > > > =====
> > > > > > > Stephane Paquette
> > > > > > > DBA Oracle
> > > > > > > stephane_paquette_at_yahoo.com
> > > > > > >
> > > > > > >
> > > __________________________________________________
> > > > > > > Do You Yahoo!?
> > > > > > > Get email at your own domain with Yahoo!
> > > Mail.
> > > > > > > http://personal.mail.yahoo.com/
> > > > > > > --
> > > > > > > Please see the official ORACLE-L FAQ:
> > > > > > http://www.orafaq.com
> > > > > > > --
> > > > > > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > > > > > > INET: stephane_paquette_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).
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ:
> > > > > > http://www.orafaq.com
> > > > > > --
> > > > > > Author: Trassens, Christian
> > > > > > INET: CTrassens_at_uni2.es
> > > > > >
> > > > > > 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).
> > > > >
> > > > >
> > > > > =====
> > > > > Stephane Paquette
> > > > > DBA Oracle
> > > > > stephane_paquette_at_yahoo.com
> > > > >
> > > > >
> > > __________________________________________________
> > > > > Do You Yahoo!?
> > > > > Get email at your own domain with Yahoo! Mail.
> > > > > http://personal.mail.yahoo.com/
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > > --
> > > > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > > > > INET: stephane_paquette_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
> > === message truncated ===
> >
> >
> > =====
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_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).

>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Trassens, Christian
>   INET: CTrassens_at_uni2.es
>
>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
Received on Mon Jan 15 2001 - 11:43:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US