 | |
Block Corruption in empty pages in Oracle 11g
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Block Corruption in empty pages in Oracle 11g -
08-15-2010
, 10:30 AM
|
On Aug 14, 2:57*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote: On Fri, 13 Aug 2010 21:32:32 -0700, zigzagdna wrote: Can some one explain following ooutput from dbv; Have you tried the documentation? --http://mgogala.byethost5.com Yes, *I have read the documentation. Based on the documenation; my block corruption is in unused blocks; i.e.; thes eblocks are not being used by current data and indexes. But, I get errors when doing delete or truncate; so documentaion is not correct or dbv is provding incorret information. Based on documentaion, I cannot figure out |
1. select without error.
2. insert without error
2. but truncare gives error
3. delete of all the rows gives error; one may be able to delete some
rows; but do not know which ones.
So either dbv output is misleading or I do not unserstand what does it
mean?
#22
| |||
| |||
|
|
On Aug 14, 11:51*pm, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:> On Aug 14,2:57*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote: On Fri, 13 Aug 2010 21:32:32 -0700, zigzagdna wrote: Can some one explain following ooutput from dbv; Have you tried the documentation? --http://mgogala.byethost5.com Yes, *I have read the documentation. Based on the documenation; my block corruption is in unused blocks; i.e.; thes eblocks are not being used by current data and indexes. But, I get errors when doing delete or truncate; so documentaion is not correct or dbv is provding incorret information. Based on documentaion, I cannot figure out Questions remain why corrupt table I can do: 1. select without error. 2. insert without error 2. but truncare gives error 3. delete of all the rows gives error; one may be able to delete some rows; but do not know which ones. So either dbv output is misleading or I do not unserstand what does it mean? |
they may have had data in them at one time and your delete from
<table_name> may be scanning all allocated blocks for that table
including the currently unused ones which would cause your error.
Truncate processes every block allocated to the table, again providing
reason for the error to surface. Simply because those blocks are
empty now does not indicate in any way that they were never used to
contain data. Thus, dbv is not misleading, it's your concept of empty
(unused) blocks with respect to your situation.
David Fitzjarrell
#23
| |||
| |||
|
|
On Aug 14, 11:51*pm, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:> On Aug 14,2:57*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote: On Fri, 13 Aug 2010 21:32:32 -0700, zigzagdna wrote: Can some one explain following ooutput from dbv; Have you tried the documentation? --http://mgogala.byethost5.com Yes, *I have read the documentation. Based on the documenation; my block corruption is in unused blocks; i.e.; thes eblocks are not being used by current data and indexes. But, I get errors when doing delete or truncate; so documentaion is not correct or dbv is provding incorret information. Based on documentaion, I cannot figure out Questions remain why corrupt table I can do: 1. select without error. 2. insert without error 2. but truncare gives error 3. delete of all the rows gives error; one may be able to delete some rows; but do not know which ones. So either dbv output is misleading or I do not unserstand what does it mean? |
or skip these corrupt blocks? You can read here:
http://download.oracle.com/docs/cd/B...r.htm#ADMIN022
to provide a step-by-step method for using the package in situations
such as yours.
David Fitzjarrell
#24
| |||
| |||
|
|
On Aug 15, 11:30*am, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote: On Aug 14, 11:51*pm, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:> On Aug 14, 2:57*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote: On Fri, 13 Aug 2010 21:32:32 -0700, zigzagdna wrote: Can some one explain following ooutput from dbv; Have you tried the documentation? --http://mgogala.byethost5.com Yes, *I have read the documentation. Based on the documenation; my block corruption is in unused blocks; i.e.; thes eblocks are not being used by current data and indexes. But, I get errors when doing delete or truncate; so documentaion is not correct or dbv is provding incorret information. Based on documentaion, I cannot figure out Questions remain why corrupt table I can do: 1. select without error. 2. insert without error 2. but truncare gives error 3. delete of all the rows gives error; one may be able to delete some rows; but do not know which ones. So either dbv output is misleading or I do not unserstand what does it mean? Have you given thought to using the DBMS_REPAIR package to either fix or skip these corrupt blocks? *You can read here: http://download.oracle.com/docs/cd/B.../b14231/repair... to provide a step-by-step method for using the package in situations such as yours. David Fitzjarrell- Hide quoted text - - Show quoted text - |
does not do what is suppoed to do. In my many years of dba caeer;
first time I am encountering block corruption to my surpise I fouud
dbms_repair packacge does not work. I had posted problem with
dbms_repair in a forum in Oarcle General News Grop on technet and no
one could
tell me why dbms_repai doe snot work.
#25
| |||
| |||
|
|
On Aug 15, 8:41*pm, ddf <orat... (AT) msn (DOT) com> wrote: On Aug 15, 11:30*am, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote: On Aug 14, 11:51*pm, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:> On Aug14, 2:57*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote: On Fri, 13 Aug 2010 21:32:32 -0700, zigzagdna wrote: Can some one explain following ooutput from dbv; Have you tried the documentation? --http://mgogala.byethost5.com Yes, *I have read the documentation. Based on the documenation; my block corruption is in unused blocks; i.e.; thes eblocks are not being used by current data and indexes. But, I get errors when doing delete or truncate; so documentaion is not correct or dbv is provding incorret information. Based on documentaion, I cannot figure out Questions remain why corrupt table I can do: 1. select without error. 2. insert without error 2. but truncare gives error 3. delete of all the rows gives error; one may be able to delete some rows; but do not know which ones. So either dbv output is misleading or I do not unserstand what does it mean? Have you given thought to using the DBMS_REPAIR package to either fix or skip these corrupt blocks? *You can read here: http://download.oracle.com/docs/cd/B.../b14231/repair... to provide a step-by-step method for using the package in situations such as yours. David Fitzjarrell- Hide quoted text - - Show quoted text - Thanks a lot for your respose. For some reason dbms_repair packacge does not do what is suppoed to do. In my many years of dba caeer; first time I am encountering block corruption to my surpise I fouud dbms_repair packacge does not work. I had posted problem with dbms_repair in a forum in Oarcle General News Grop on technet and no one could tell me why dbms_repai doe snot work. |
--
Jeroen
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.