Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: quckways to find block corruption
FWIW .... I like to do full exports in the middle of the night
just for this reason as a hot backup wont cut it.
If you find a corrupt block you can fix it using
either a PL/SQL or PRO*C rountine that can be
found on Metalink.
Search for corrupt blocks.
Mike
-----Original Message-----
Sent: Monday, September 23, 2002 3: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 - 16:48:24 CDT
![]() |
![]() |