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: Trassens, Christian <CTrassens_at_uni2.es>
Date: Mon, 15 Jan 2001 16:48:23 +0100
Message-Id: <10742.126677@fatcity.com>


With the "format" command. There is an option for scanning.

> -----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 ?

>=20

> Hi,
>=20

> This is linked to my ora-600 problem.
> Of course, the SA is not here today.
>=20

> 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
>=20

> TIA
>=20

> --- "Trassens, Christian" <CTrassens_at_uni2.es> a
> =E9crit : > 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 ?.
> >=20
> > Regards.
> >=20
> > > -----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
> > >=20
> > > So, let us know the workaround.....if it had one.
> > >=20
> > > > -----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
> > > >=20
> > > > 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).
> > > >=20
> > > > According to Oracle, it seems to be a corruption
> > in
> > > > uet$ (all my tbs are locally managed except
> > system)
> > > >=20
> > > > Oracle will open a new bug. (Do I have a t-shirt
> > ?)
> > > >=20
> > > > What bothers me is that it can happen again
> > since no
> > > > correction have been applied.=20
> > > >=20
> > > > =20
> > > >=20
> > > > --- "Trassens, Christian" <CTrassens_at_uni2.es> a
> > > > =E9crit : > Hi,
> > > > >=20
> > > > > You've received the symptons of the bug
> > 1397075.
> > > > > Have you dropped a read
> > > > > only tablespace locally managed ??.
> > > > >=20
> > > > > 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;
> > > > >=20
> > > > > Regards.
> > > > >=20
> > > > > > -----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
> > > > > >=20
> > > > > > Hi,
> > > > > >=20
> > > > > > 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.
> > > > > >=20
> > > > > > I started them but just after the db are
> > opened,
> > > > > smon
> > > > > > crash them with have ORA-600 [kcbgcur_9].
> > > > > >=20
> > > > > > Since there is an ORA-600, I've called
> > Oracle
> > > > > support.
> > > > > >=20
> > > > > > If anyone had this one, I'd be glad to hear
> > it.
> > > > > >=20
> > > > > > TIA
> > > > > >=20
> > > > > > =3D=3D=3D=3D=3D
> > > > > > Stephane Paquette
> > > > > > DBA Oracle
> > > > > > stephane_paquette_at_yahoo.com
> > > > > >=20
> > > > > >
> > __________________________________________________
> > > > > > Do You Yahoo!?
> > > > > > Get email at your own domain with Yahoo!
> > Mail.=20
> > > > > > http://personal.mail.yahoo.com/
> > > > > > --=20
> > > > > > Please see the official ORACLE-L FAQ:
> > > > > http://www.orafaq.com
> > > > > > --=20
> > > > > > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > > > > > INET: stephane_paquette_at_yahoo.com
> > > > > >=20
> > > > > > Fat City Network Services -- (858)
> > 538-5051=20
> > > > > 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).
> > > > > --=20
> > > > > Please see the official ORACLE-L FAQ:
> > > > > http://www.orafaq.com
> > > > > --=20
> > > > > Author: Trassens, Christian
> > > > > INET: CTrassens_at_uni2.es
> > > > >=20
> > > > > 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).
> > > >=20
> > > >=20
> > > > =3D=3D=3D=3D=3D
> > > > Stephane Paquette
> > > > DBA Oracle
> > > > stephane_paquette_at_yahoo.com
> > > >=20
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Get email at your own domain with Yahoo! Mail.=20
> > > > http://personal.mail.yahoo.com/
> > > > --=20
> > > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > > --=20
> > > > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > > > INET: stephane_paquette_at_yahoo.com
> > > >=20
> > > > Fat City Network Services -- (858) 538-5051=20
> > 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=20
> =3D=3D=3D message truncated =3D=3D=3D
>=20
>=20

> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
>=20

> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.=20
> http://personal.mail.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20

> 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
Received on Mon Jan 15 2001 - 09:48:23 CST

Original text of this message

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