Go Premium for a chance to win a PS4. Enter to Win


Restore particular tables from RMAN backup

Posted on 2013-01-22
Medium Priority
Last Modified: 2013-01-22
Experts -

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

Question by:sventhan
  • 4
  • 2
LVL 18

Author Comment

ID: 38806931
I mean restore/recovering particular tables.
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 38806951
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.
LVL 18

Author Comment

ID: 38806974
<< 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.
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38806989
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.
LVL 18

Author Comment

ID: 38806993
In metalink they're talking about RMAN tablespace point in time recovery. I'm looking into this now.
LVL 18

Author Closing Comment

ID: 38807134

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question