Peter - Kevin Kennedy on the list (hope you don't mind me giving you credit,
Kevin) noticed that your tablespace was named "RBS1". Maybe you can simply
drop and recreate the rollback segment?
But also turn on the parameters to make sure you aren't propagating
corruption.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, June 11, 2002 12:45 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
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: [EMAIL PROTECTED]
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: [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 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: [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).
