| 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 Birkir,
If the "empty" corrupted blocks are not within a segment extent or are not below the HWM of a segment, then you have a beautiful horse to ride on a straight and wide course.
IE, you should be OK ;)
Test by exporting the tablespace (9i ?) in question would probably be worthwhile.
Cheers
Richard
----- Original Message -----
From: "Birkir Bjornsson" <birkir_at_teymi.is>
To: <oracle-l_at_freelists.org>
Sent: Friday, March 05, 2004 11:30 PM
Subject: 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
> >-----------------------------------------------------------------
> >
> >
>
>
> ----------------------------------------------------------------
> 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:48:02 CST
 |
 |