Re: db corruption

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Aug 2006 10:16:39 -0400
Message-Id: <1155651399l.4041l.2l@medo.noip.com>

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

Received on Tue Aug 15 2006 - 09:16:39 CDT