Re: EXP/IMP due to corrupt blocks
- From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 6 Mar 2004 00:16:17 +1000
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@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
