RE: Query Fails for particular date
Date: Wed, 22 Jul 2009 16:34:31 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9042A2211_at_usahm208.amer.corp.eds.com>
It is sometime possible to repair a corrupt block depending on the issue.
If the corruption is in the row data then you can generally delete the one row and re-insert it.
If the corruption is in the header somewhere but the header row table is OK you might be able to extract all the data.
See the dbms_repair package as user sys.
- Mark D Powell -- Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of D'Hooge Freek
Sent: Wednesday, July 22, 2009 2:26 AM
To: nagaraj.chk_at_gmail.com
Cc: oracle-l
Subject: RE: Query Fails for particular date
Hi,
That depends on your backup strategy.
If you are using rman, you could try block level recovery. Otherwise you
need to restore the datafile from a time before the corruption.
But you said that you already needed to restored this datafile last
month, so it could be that the corruption was already there since long
time.
Maybe it is best to open a case with oracle to see how to proceed further?
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 23:17
To: D'Hooge Freek
Cc: oracle-l
Subject: Re: Query Fails for particular date
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)
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 22 2009 - 15:34:31 CDT