RE: db corruption

i've had rman tell me blocks were corrupt before. i waited a few days to do anything about it because it was in a non critical tablespace in a development datbase. The problem silently went away. I opened a tar with oracle to find out what happened. The response I got from oracle support was that the block was probably empty and once data was inserted into it, the corruption was fixed.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: Tuesday, August 15, 2006 9:31 AM
To: gogala_at_sbcglobal.net; joseph.armstrong-champ_at_tufts.edu Cc: ORACLE-L
Subject: RE: db corruption

Definitely second Mladen's recommendation. A quick & dirty way to find possible suspect tables (assuming Oracle knows what it wants to do with logging/nologging in its' own tables) is something like this. You may want to add/change excluded schemas based on the options you have installed.  

hth,

-joe  

select owner||'.'||table_name from dba_tables

where logging <> 'YES' (*** or logging = 'NO' ***)

and owner not in ('SYS', 'SYSTEM', 'DBSNMP', 'WKSYS', 'OLAPSYS', 'WMSYS', 'MDSYS', 'BIBCAT') order by owner, table_name;  

> -----Original Message-----

> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]

> On Behalf Of Mladen Gogala

> Sent: Tuesday, August 15, 2006 8:17 AM

> To: joseph.armstrong-champ_at_tufts.edu

> Cc: ORACLE-L

> Subject: Re: db corruption

>

>

> On 08/15/2006 09:57:31 AM, Joe Armstrong-Champ wrote:

>

> >

> > We were wondering what other shops do to detect corruption. Also
does

> > anyone have any recommended reading for how to fix it once it's been

> > detected? This is probably the hardest part depending on the extent
of

> > the damage.

>

> There might have been a logical corruption, usually a result of
restoring

> tablespaces

> with indexes created as "NOLOGGING". First thing to do is to verify
that

> you can actually

> restore the backup with "restore database verify".

>

>

> --

> Mladen Gogala

> http://www.mgogala.com

>

> --

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

>
 

CONFIDENTIALITY NOTICE:
        This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

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