RE: Oracle database consistency checks

I should mention, for completeness, that for block corruption *protection* (as opposed to post hoc detection), one can set block checksumming and logical block checking as well,

AND you can use DBMS_REPAIR ( another one of the built-ins i referred to earlier)
to perform a number of actions.

AND/OR Support can help you with special-purpose "salvage" scripts, both in Pro*C (or whatever it's called now) and SQL.

hth!

• Ross Mohan

-----Original Message-----
From: Mohan, Ross [mailto:Ross.Mohan_at_picturevision.com] Sent: Monday, October 09, 2000 7:30 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Oracle database consistency checks

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. :-(

|| OUCH!!!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: Ross.Mohan_at_PictureVision.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).