Re: Query Fails for particular date

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Wed, 22 Jul 2009 02:47:46 +0530
Message-ID: <e921f8570907211417u490d20a7x4d14dfd60141fb6f_at_mail.gmail.com>

Your right Freek. the datafile show block corruption. How to proceed now

Page 2969392 is marked corrupt
Corrupt block relative dba: 0x18ed4f30 (file 99, block 2969392) Completely zero block found during dbv:

DBVERIFY - Verification complete

Total Pages Examined         : 3628808
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 2340725
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 41655
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1245484
Total Pages Marked Corrupt   : 944
Total Pages Influx           : 0
Highest block SCN            : 1597765560 (1267.1597765560)

On Wed, Jul 22, 2009 at 1:51 AM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:

> my first thought would be a corrupt block.
> Did you run dbverify on the datafile(s) in which the table is existing?
>
>
> regards,
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> e-mail: freek.dhooge_at_uptime.be
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
> disclaimer
>
>
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On
> Behalf Of Nagaraj S [nagaraj.chk_at_gmail.com]
> Sent: 21 July 2009 19:39
> To: oracle-l
> Subject: Query Fails for particular date
>
>
> Hi Gurus,
>
> We receive error ,while we run the below sql query for a particular date
> 18-AUG-07. We did a restore of these table partitions last month, So we are
> in doubt of any data corruptions. Query runs fine for all other days except
> for 18-AUG-07.
> SQL> select
> .........
> .
> .............
> .....
> and b.ps_dat_org = '18-AUG-07';
> from sysadm.sysadm_paymen_teac a, sysadm.sysadm_paymen_recb
> *
> ERROR at line 13:
> ORA-08103: object no longer exists
>
>
> Kindly advice.
>
> -Naga
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 21 2009 - 16:17:46 CDT