Re: EXP/IMP due to corrupt blocks
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 10:27:36 -0400
Always do a block disk checkdisk in nt you have to run chkdsk x: /r
Some times this fix t he problem, and you have to do nothing in the
database.
----- Original Message -----
From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 05, 2004 10:48 AM
Subject: 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@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
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
