RE: Oracle database consistency checks

From: Mohan, Ross <Ross.Mohan_at_PictureVision.com>
Date: Mon, 9 Oct 2000 18:24:46 -0400
Message-Id: <10644.118835@fatcity.com>

I don't necessarily agree with this. Only a manual run of DBV revealed the problem in both cases here.

|| sorry, didn't see the cases you cite. In general, one should run
ANALYZE *and* dbv for the best in block corruption detection. Please be aware that running dbv on a live database is ok, but will report spurious "errors" on blocks that are in transition.

I've had two different instances where dbv has reported "corrupt" files.

|| did you run it on a pre 8i "non" data database file ( i.e. a redo, temp,
or rollback segment? ) and for 8i binaries, did you run it on a COLD database?

In one case it was the SYSTEM tablespace that was corrupt.

|| which object? SYSTEM can/may contain RBS which, in pre8i are NOT
designed to be "dbv'ed".

hth!

My only option was a FULL export/import. :-( Received on Mon Oct 09 2000 - 17:24:46 CDT