Re: Query Fails for particular date
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: "D'Hooge Freek" <Freek.DHooge@xxxxxxxxx>
- Date: Wed, 22 Jul 2009 02:47:46 +0530
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@xxxxxxxxx>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@xxxxxxxxx
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
> disclaimer
>
>
> From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Nagaraj S [nagaraj.chk@xxxxxxxxx]
> 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
>
Other related posts:
