| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: quckways to find block corruption
Srinivas
I think that as a minimum, to detect corruption you must read all data blocks. There are several methods, most involve an Oracle process that will error if a corrupt block is encountered. Export to /dev/null was mentioned already. I have used ANALYZE TABLE VALIDATE STRUCTURE CASCADE, which will also check out the indexes and verify they point to good blocks, but is quite resource intensive. If you use RMAN to back up your database, then as a bonus it always verifies your data blocks and will error out when it encounters a bad block.
I haven't used dbv personally, but assume that dbv was one of the most
efficient methods of checking your datafiles since it runs outside Oracle
and therefore doesn't tie up your Oracle resources. Perhaps you can spell
out the problems you are encountering with dbv and what you are trying to
accomplish in more detail.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
-----Original Message-----
Sent: Monday, September 23, 2002 5:03 AM
To: Multiple recipients of list ORACLE-L
Hello all,
DB: 8i
OS: solaris 2.7
can somebody post me reply for this.
is there any quick way to find which datablocks are corrupted in my oracle database .
( other than dbverify and rman backup. )
b'coz we have BCV backup already implemented and we cannot do a dbv every week for 500 gig production database .
thanks in advance,
srinivas
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Mon Sep 23 2002 - 11:08:24 CDT
 |
 |