Re: Import Data Into Table With ORA-01578 Error

From: gazzag <gareth_at_jamms.org>
Date: Thu, 13 Nov 2008 07:55:52 -0800 (PST)
Message-ID: <4b848d2d-4422-4eeb-8333-d20ee1a37de1@d10g2000pra.googlegroups.com>


On 13 Nov, 15:15, myocarditis_recovering <myocarditis_recover..._at_yahoo.com> wrote:
> Hi,
>
> We have a case, in Windows (9i), of "ORA-01578: ORACLE data
> block corrupted (file # x, block # y)". We know the table which this
> affects,
> as well as the primary keys of the records stored in this block and
> file.
> (For the purposes of this post, say, table A, keys PK1 and PK2).
>
> What's more, we know that the ORA-01578 had occurred in a previous
> server, not the existing one into which this database was copied.
> (Through dbv of previous backups, etc..)
>
> We also have other databases with identical data for the records
> in the corrupted data blocks.
>
> My intention is to, somehow, export the data from another database
> and import it into the one with the ORA-01578 error. I can export the
> data; That is not the issue.
>
> At first, I tried deleting keys PK1 and PK2 from table A,
> but ORA-01578 prevented this.(As I had expected).
>
> Then,  I tried copying table A to table B and bypassing the corrupted
> block (With the intention of dropping table A, importing the missing
> data into table B, and  copying it to A) through the command:
>
>  create table B as select * from A where
>  dbms_rowid.rowid_block_number(rowid)  <> y;
>
> However, the ORA-01578 error appeared (For block y)
>
> Is there a way for me to copy the identical data from another
> database
> into the one with the ORA-01578 error (Though the physical corruption
> was on another server).
>
> Any ideas would be appreciated.
>
> Thanks,
> DF

I agree with David Fitzjarrell.

However, as an academic exercise in the meantime, how about using RMAN to back up and restore to another host?

HTH -g Received on Thu Nov 13 2008 - 09:55:52 CST

Original text of this message