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 __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Johnson, Michael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
