Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

recover info from table partition with missing offline datafile

759679Mar 12 2010 — edited Mar 13 2010
I just restored a backup of a database; when i unzipped the datafiles i found out that one datafile was damaged so in order to startup the database i had to put the datafile offline. The tablespace which the datafile belongs to holds the information of one table partition. Since i don't have archives from the time the datafile was created i know it wont be posible to recover the datafile, what i what is to recover as much rows as posible from the remaining datafiles in the tablespace but when i to export or create table as select from the affected partition y get ORA-00376: file 1624 cannot be read at this time.

is there a way to tell oracle to skip the offline datafile and export the information of the remaining datafiles?

Just to clarify my situation a little more;
iI have a table called PPGA_ACTABOPRE which is partitioned by HASH and has 20 partitions, each partition in a different tablespace and each tablespace has about 8 datafiles. One datafile in the 9th partition is missing and i want is to recover the info from the remaining datafiles but every time i issue a select or a exp or whatever i get ORA-00376.

I try to set the flag to skip corrupted blocks with execute DBMS_REPAIR.SKIP_CORRUPT_BLOCKS('PPGA','PPGA_ACTABOPRE'); and then select the info but it didnt work.

Any suggestions would be appreciated;
Thanks in advance
This post has been answered by Robert Geier on Mar 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2010
Added on Mar 12 2010
5 comments
1,757 views