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
Received on Mon Oct 09 2000 - 20:40:36 CDT
