| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: EXP/IMP due to corrupt blocks
Hi Richard
There is no data in the corrupt blocks in the datafiles, so they are empty. So do you think that the export will fail because of empty corrupt blocks?
Richard Foote wrote:
>Hi Birkir,
>
>You maybe forgetting that your export will fail once it comes across one of
>the corrupted blocks !!
>
>You need to fix the corruptions which depends entirely on the nature of the
>corruption, what's actually corrupted, are the objects re-creatable, is the
>corruption in your backups (else restore and recover of datafiles could be
>an option), database version (dbms_repair), can you afford to lose the
>corrupted data, is it in a LOB (nasty but solvable), investigate block
>dumps, etc. etc.
>
>I've fixed plenty of corruptions in my time and it's usually a case of
>horses for courses.
>
>But exp/imp is unlikely to be your solution.
>
>Good Luck
>
>Richard
>----- Original Message -----
>From: "Birkir Bjornsson" <birkir_at_teymi.is>
>To: <oracle-l_at_freelists.org>
>Sent: Friday, March 05, 2004 10:47 PM
>Subject: EXP/IMP due to corrupt blocks
>
>
>
>
>>Hi
>>
>>I hava a database with corrupt blocks. And I was thinking of exporting
>>the database and then import it
>>on another machine because of faulty hardware.
>>
>>So isnt this the right approach for this, create the tablespaces, and
>>users on the new database and then import from user to user?
>>
>>Is there anything im forgetting?
>>
>>Kind Regards
>>Bippi
>>
>>
>>
>>----------------------------------------------------------------
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>----------------------------------------------------------------
>>To unsubscribe send email to: oracle-l-request_at_freelists.org
>>put 'unsubscribe' in the subject line.
>>--
>>Archives are at http://www.freelists.org/archives/oracle-l/
>>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>>-----------------------------------------------------------------
>>
>>
>>
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Mar 05 2004 - 07:28:39 CST
 |
 |