db corruption

From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>
Date: Tue, 15 Aug 2006 09:57:31 -0400
Message-ID: <44E1D2CB.8070408@tufts.edu>

environment: Oracle EE 9.2.0.7/AIX 5.2

We had a bit of a scare a few weeks ago when RMAN reported a corrupt block during a backup. V$DATABASE_BLOCK_CORRUPTION had no data, a dbverify showed up nothing and an export also showed nothing. We reviewed Note:28814.1 (Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g) during the crisis which helped. After talking to oracle it was decided that it was a false alarm. Oracle told us that they couldn't investigate and we didn't pursue it.

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.

Thanks.
Joe

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

Received on Tue Aug 15 2006 - 08:57:31 CDT