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" <[EMAIL PROTECTED]> >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: '[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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: VIVEK_SHARMA > 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). > > > -- /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 */
smime.p7s
Description: application/pkcs7-signature
