Re: EXP/IMP due to corrupt blocks

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 6 Mar 2004 00:16:17 +1000
Message-ID: <0aa301c402bc$6ceee800$0100000a@FOOTE>

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

Received on Fri Mar 05 2004 - 07:10:40 CST