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