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!

Restore certain tables in Prod from a backup by skipping already existing data

2893506Feb 26 2015 — edited Mar 4 2015

HI All,

There was a upload performed in our production database couple of weeks back, and we have noticed that it has deleted certain related data (in thousands) from other tables. We would like restore the deleted records in to the tables with data from a backup DB that we had before the upload.

Could someone please suggest what is the best way to restore the deleted data in these tables. There are around 5 tables that needs to be restored and couple of them haveĀ  more than a million records, so we are finding it hard to compare the prod DB and the backup DB to determine what was deleted and how to insert it back.

I was wondering if Is there a way that we can export the tables from the backup DB, and import it into our prod DB, and during import somehow skip the data which is already existing in the target table. (Based on a unique ID column). If this is a possibility we would effectively be putting back whatever was deleted as a result of upload.

We are currently using Oracle Database 11g Enterprise Edition.

I would be very thankful to any pointers in this regard.

Thanks

AK

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2015
Added on Feb 26 2015
7 comments
614 views