Oracle-L: RE: ORA-00604 and ORA-01578

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 13 Jun 2002 05:53:40 -0800
Message-ID: <F001.0047CEE5.20020613055340@fatcity.com>

Vivek - Several people on this list are using it, and not reporting a noticeable performance impact. In an Oracle class last fall, the instructor tossed of "under 10%". The one you want to avoid is DB_BLOCK_CHECKSUM. I believe Oracle recommends you use this one only at the direction of their support people.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, June 13, 2002 6:24 AM
To: Multiple recipients of list ORACLE-L

Is there any PERFORMANCE Overhead on Setting DB_BLOCK_CHECKING = TRUE in the init.ora .
Any Best practice on this parameter Setting ?

Thanks

-----Original Message-----
Sent: Wednesday, June 12, 2002 12:34 AM
To: Multiple recipients of list ORACLE-L

Resend.

-----Original Message-----
Sent: Tuesday, June 11, 2002 12:45 PM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'peter.lee_at_honeywell.com'

Peter - You can use the DBMS_REPAIR package included with Oracle to locate the corrupt blocks. If the data in the corrupted blocks is extremely important, you can use this to dump the block contents. Then you can change the blocks so Oracle will skip the corrupted blocks. Then you can export the table or copy the contents to another table.

Dropping the tables and recreating it from your export is also an option.

	Don't forget to rebuild indexes afterward.
	Run ANALYZE TABLE VALIDATE CASCADE to find any other corrupt blocks
in other tables.
	And turn on the init.ora parameter DB_BLOCK_CHECKING to detect any

further corruptions before they occur.
Good luck.

-----Original Message-----
Sent: Tuesday, June 11, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L

I have a system when I issued a select statement, I get the following error.

ORA-00604 Error Occur at recursive level 1

ORA-01578 Oracle Datablock corrupted. File 6 Block 2853

ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS

We have an export that we may be able to restore. The database is running in non-archive mode. Any idea on how to resolve this problem?

Thank you in advance
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: peter.lee_at_honeywell.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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------