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

Home -> Community -> Usenet -> c.d.o.server -> Re: 2 questions: data block corruption + good oracle troubleshoooting sites

Re: 2 questions: data block corruption + good oracle troubleshoooting sites

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 29 Mar 2001 17:05:58 +0100
Message-ID: <3ac362ee$0$12244$cc9e4d1f@news.dial.pipex.com>

orafaq.com is good

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Jose Aragao" <ubik_at_hotvoice.com> wrote in message
news:dxow6.151$J73.2702_at_nreader2.kpnqwest.net...

> Hello.
>
> 2 questions:
>
> - I'm having the following error when accessing Oracle using SQL
Navigator:
>
> ORA-01578: ORACLE data block corrupted (file # 1, block # 40401)
> ORA-01110: data file 1: '/home/oracle/data1/oradata/ORCL/system01.dbf'
>
> I know that there is data block corruption (duh!) and that i have to
restore
> the segment with block # 40401, but i don't know if this recovering of the
> segment will cause loss of data. Is that the case?
>
>
> - Can anyone point me to some good oracle/sql sites? You know, those that
> you go to when you have a doubt or are looking for faqs, one that it's not
> limited to theory. I've been brwosing around http://technet.oracle.com but
> i'd like some more "solutions".
>
> Thanks in advance...
>
> --
>
> jpa
>
>
Received on Thu Mar 29 2001 - 10:05:58 CST

Original text of this message

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