RE: Oracle database consistency checks

Thanks for saying so, and.....I hope the info is of value.....

...remember there *is* a small performance hit on setting some of these flags.........

:-) nice email address, btw!

-----Original Message-----
From: aaaa wwwwww [mailto:krisibm_at_lycos.com] Sent: Monday, October 09, 2000 10:45 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Oracle database consistency checks

Thanx Mohan ! We are benefitted !

Rao

--

On Mon, 09 Oct 2000 16:05:24  
 Mohan, Ross wrote:


>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-----

>Sent: Monday, October 09, 2000 7:30 PM

>To: Multiple recipients of list ORACLE-L

>

>

>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).

>-- 

>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).

>



10% cash back on all your calls through 2000 at Lycos Communications at
http://comm.lycos.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: aaaa wwwwww
  INET: krisibm_at_lycos.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