Restore particular tables from RMAN backup

Experts -

Is there a better/easy way of restoring particular tables from RMAN backup. The DB size is over a TB.

Thanks,
Sve
LVL 18
sventhanAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I don't know a way to recover a specific table from an RMAN backup.  RMAN is sort of an all or nothing recovery tool.

Now from a theoretical exercise, to recover a dropped/truncated table, you might be aboe to use FLASHBACK to recover it.

Short of that, I believe you will need to recover your database to a different server, grab the tables and move them over to the original.
0
 
sventhanAuthor Commented:
I mean restore/recovering particular tables.
0
 
sventhanAuthor Commented:
<< Short of that, I believe you will need to recover your database to a different server, grab the tables and move them over to the original.

Thanks Slightwv.  I wanted to find out is there an easy way to do this. If not I've to restore the whole DB.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
slightwv (䄆 Netminder) Commented:
Maybe another Expert knows some trick.

I assume these are old tables that has been around for a while?

If not, you might be able to just use the backed up archived redo files and use log miner to re-create them.
0
 
sventhanAuthor Commented:
In metalink they're talking about RMAN tablespace point in time recovery. I'm looking into this now.
0
 
sventhanAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.