Retrieve the data from Corrupted oracle table partition

Posted by PDSERVICE on Mar 02, 2017 In

User Case:

I just want to know whether we can able to recover the data from the corrupted partitions. In this case, not the whole partition got corrupted, some of the blocks in those partitions are corrupted. Unfortunately there was no backup being enabled. Could you pls let me know whether any option is there to recover those. And also let us know whether i can have any option that i can take to recover those corrupted blocks since the data is very critical for us.

Could you please let me know wether i can have any option to select the records from the table.

Because when i am trying to select the fields from the table (Where the table is partitioned (Blocks corrupted in those)), it is throwing an error "object no longer exists".

Is there any way that i can select the particular column values?

We need to get files from that table name only. Without putting a select statement we could not able to know what and all files we need to reload. That is why i have asked whether any options are there to select the particular records alone.

Feedback:

Our software Prm-dul can load the corrupted partition : data block corrupted or even segment header lost/corrupted. We can provide prm-dul as product or recovery service.

"object no longer exists". is ORA-08103 error, it means your segment has wrong extent map info . If you select any record the error will raise to prevent your querying . You can just unload this records by using PRM-DUL , and rebuild your partition .

You don't need to get files or any select statement if you use prm-dul. The software can load data from oracle datafile directly, without Oracle instance & SQL statement.

You are here

Retrieve the data from Corrupted oracle table partition

Retrieve the data from Corrupted oracle table partition