Thanks for the question, Sunil Kumar.
Asked: June 30, 2016 - 1:48 am UTC
Last updated: June 30, 2016 - 6:05 am UTC
Version: 12c, 11g, 10g
Viewed 1000+ times
You Asked
Hi Tom / Connor,
As a regular DBA Activity, everyday Production DBs are scheduled for backup and the backup files will be stored in archive location for a retention period depending on business requirement.
Now my query is, I just want to pick a specific table data from the zipped files. Is that possible by any chance ?
Ex: - I have emp table in zip file which was backed up on say, 28-June-2016 and today (30-June-2016) I realized that some of the data was corrupted and re-store is required only for emp table and not for the entire database. So, if there is any provision to only pick the data from the zip files without importing the complete data in to the database, that will be helpful.
Please let me know your thoughts.
and Connor said...
OK, I'm assuming the files have been backed up with RMAN.
In 12c, you can recover a single table from an RMAN backup. But there's no magic going on here. What RMAN does is:
- creates a new instance
- restores the tablespace the table was in
- restore system/sysaux/undo tablespaces (which you need for the dictionary and any transactions that might have been active)
- recover that "mini-database"
- take a datapump export of the table
- import it into the target database
So you could replicate those same steps manually in earlier releases.
Hope this helps.
Is this answer out of date? If it is, please let us know via a Comment