Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help on recovery Data from Oracle DB
"Pearapon S." <pearapon_at_ksc.th.com> wrote in message
news:9fj6f7$2j$1_at_taliesin.netcom.net.uk...
> Hi All,
>
> I need help on recovery Data from Oracle DB. Recently,there are some
> problems with our Oracle DB. Whenever , we try to access or select data
from
> one Table named: SCC0k21, Oracle reports "data blocked is corrupted". For
> example, when we used this statement:
>
> " select sccname, scclastname from scc0k21 where sccrtcd = '1' and
> sccampr = '01005300' and sccknum >= '165257' and sccknum <= '165356' "
>
> There is Oracle error:
>
> "ORA-01578: oracle data block corrupted (file # 44, block # 403796)
> ORA-01110: data file 44: '/usr10/sc41/dbs/sc41tscc02.dbf' "
>
> It seems that we have got there same error even if we changed the range of
> sccknum.
> However, we can select each record for each "sccknum".
> The fields: sccrtcd, sccampr and sccknum are indexed keys.
>
> We also try to create new Table based on the data of this table by using:
>
> "Create table new0k21 tablespace newtbs as select * from scc0k21"
>
> However, there is still this kind of "data block corrupted" ,but on
> different locations
>
> We use:
>
> - Oracle 7.3.4 on SUN Solaris 2.6
> - there are about 6,000,000 records in SCC0k21 table ( about 2.5 GB )
>
> Cloud you please help us ? It is very important for us to recover this
Data
> and make this DB work as normal as soon as possible. Thank you very much
in
> advance. Your help are very much appreciated. Please....
>
> Best Regards,
> Pearapon S.
> pearapon_at_ksc.th.com
>
>
>
>
>
>
>
1 Please don't post to multiple groups and don't crosspost. You're not
getting a bigger audience
2 replace the faulty disk
3 restore the database from a backup
4 perform complete recovery
5 please stop using desupported software
Hth,
Sybrand Bakker, Oracle DBA Received on Tue Jun 05 2001 - 13:51:45 CDT