Re: db corruption

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: joseph.armstrong-champ@xxxxxxxxx
  • Date: Tue, 15 Aug 2006 10:16:39 -0400

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

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


Other related posts: