Re: EXP/IMP due to corrupt blocks
- From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 6 Mar 2004 00:48:15 +1000
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@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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
> >-----------------------------------------------------------------
> >
> >
>
>
> ----------------------------------------------------------------
> 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:
