[Oracle-l] ORA-00604 and ORA-01578

--
Danisment Gazi Unal
http://www.ubTools.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal (ubTools)
INET: dunal_at_ubTools.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).

-----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
--------------------------------------------------------------------

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).

-----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
--------------------------------------------------------------------

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).

--
Danisment Gazi Unal
http://www.ubTools.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal (ubTools)
INET: dunal_at_ubTools.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).

----- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, June 11, 2002 7:28 PM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: adar76_at_inter.net.il

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).

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

Hello

Since the tablespace looks like RBS you may be able to drop that tablespace
and
recreate it again, assuming that your update transaction finished ok and the
select
use the RBS to get old values since an update is in progress.

I think that you should run also an OS disk checking utility to verify
that the problem is not a bad block/sector on the disk itself.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, June 11, 2002 7:28 PM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: adar76_at_inter.net.il

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:
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).

-----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
--------------------------------------------------------------------

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: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.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).

-----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
--------------------------------------------------------------------

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: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.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
--------------------------------------------------------------------

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).

----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
Sent: Thursday, June 13, 2002 4:23 AM

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
--------------------------------------------------------------------
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: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.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: BigP
INET: big_planet_2000_at_hotmail.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).

--

/regards

Peter Gram

Mobil : +45 2527 7107
Fax : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk

/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like
composing poetry or music

Donald Knuth
*/

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms080007060506070908040607--

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Gram
INET: peter.gram_at_miracleas.dk

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).

application/x-pkcs7-signature attachment: smime.p7s