Re: ORA-01578: ORACLE data block corrupted

  • From: Saurabh Sood <email2sood@xxxxxxxxx>
  • To: po04541@xxxxxxxxx
  • Date: Tue, 23 Mar 2010 12:03:39 +0530

Hi,

You can use event 10231 to complete the import process.
refer to following link for the complete resolution of ora-1578:

http://askdba.org/weblog/2008/05/ora-1578-ora-8103-corruption/


Cheers!!!
Saurabh Sood


On Tue, Mar 23, 2010 at 3:04 AM, patrick obrien <po04541@xxxxxxxxx> wrote:

> Hello my good oracle friends,
>
> ( to start out, thanks for all of your help with my past problems. )
>
> Oracle Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> I've got the following importing, not sure the best fix?? thank you!
>
> Mead:oracle$ exp parfile=AD_OBJATCH.par
>
> Export: Release 8.1.6.2.0 - Production on Mon Mar 22 14:27:16 2010
>
> (c) Copyright 1999 Oracle Corporation.  All rights reserved.
>
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.2.0 - Production
> Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
> set
>
> About to export specified tables via Conventional Path ...
> Current user changed to AMS_AFINADM
> . . exporting table                     AD_OBJATCH
> EXP-00056: ORACLE error 1578 encountered
> ORA-01578: ORACLE data block corrupted (file # 54, block # 345609)
> ORA-01110: data file 54: '/u10/dbs/fsco/object02.dbf'
> Export terminated successfully with warnings.
>
>
>


-- 
SAURABH SOOD
ORA-DBA

Other related posts: