For those of you that are hitting corrupt blocks frequently enough to be
this current on it, I assume you are using the parameters introduced in
8.1.6 to keep on top of this,
db_block_checking
db_block_checksum
�
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
Sent: Monday, September 23, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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).
