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

Search Discussions

  • Danisment Gazi Unal (ubTools) at Jun 11, 2002 at 7:04 pm
    Hi,

    First of all, find the corrupted object by the following SQL:

    Select segment_name, segment_type

    from dba_extents
    where file_id= and
    between block_id and block_id + blocks -1;

    Most probably, it's an rbs. If you have time to import, do it. If not, add
    following parameters to init.ora and restart db:

    event = "10015 trace name context forever, level 10"

    Then, email the trace file.

    regards...

    peter.lee_at_honeywell.com wrote:
    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).
    --
    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).
  • DENNIS WILLIAMS at Jun 11, 2002 at 7:04 pm
    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).
  • DENNIS WILLIAMS at Jun 11, 2002 at 7:59 pm
    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.
    dwilliams_at_lifetouch.com

    -----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 (ubTools) at Jun 11, 2002 at 8:49 pm
    Hi,

    I think he will not be able to drop rbs since there is an active transaction in
    this rbs. But, if he can recreate his table, there will be no need this
    corrupted rbs. Then, he can recreate this rbs.

    regards...

    DENNIS WILLIAMS wrote:
    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.
    dwilliams_at_lifetouch.com

    -----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).
  • Yechiel Adar at Jun 12, 2002 at 5:43 pm
    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
    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: 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).
  • Peter.lee_at_honeywell.com at Jun 12, 2002 at 6:55 pm
    Thank you to all those that replied. Unfortunately, the corruption on the
    hardware has caused other files to be corrupted. We had to restore the
    database using the export dump file after fixing the hardware problem.

    Thank you to all those that replied.

    Pete

    -----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
    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: 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).
  • VIVEK_SHARMA at Jun 13, 2002 at 11: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).
  • DENNIS WILLIAMS at Jun 13, 2002 at 1:53 pm
    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
    --------------------------------------------------------------------

    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).
  • BigP at Jun 14, 2002 at 12:28 am
    Just to learn this thing, ..how can I corrupt a block in my test
    environment .
    ohhhh ..... but be ready to help me if I am not able to repair it .
    Thanks,
    Bp
    ----- 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).
  • Peter Gram at Jun 14, 2002 at 9:28 am
    Hi BigP

    Create a tablespace corrupt.dbf fill it with a table. Use dd to write
    junk in the middle of the datafile and you have a ora-1578

    BigP wrote:
    Just to learn this thing, ..how can I corrupt a block in my test
    environment .
    ohhhh ..... but be ready to help me if I am not able to repair it .
    Thanks,
    Bp
    ----- 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).

    --

    /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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 11, '02 at 5:28p
activeJun 14, '02 at 9:28a
posts11
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase