0 like 0 dislike
50 views
asked in Oracle Database Forum by (4k points)  
Is there an option to recover only one table from the full RMAN backup without touching any data of other tables & schema’s.

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (4k points)  
Table restore from rman backup is a feature of enterprise edition . in this case our database edition is standard . so we can not restore table from rman backup directly . we have only available option as below .
1)    Restore entire prod database to a non-prod  server
2)    Take  export backup of  required table t1) in Non-PROD Server
3)    Take the export backup of the table (t1) in PROD
4)    Restore the table back ( from export backup dump file taken in Non-Prod server)  to the production database
5)    Verify the data , If no issues noticed then proceed with next steps else cleanup the table and import backup dump file taken from PROD.
6)    Drop the database which was restored at non prod server .

Related questions

0 like 0 dislike
0 answers
0 like 0 dislike
0 answers
0 like 0 dislike
0 answers
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
...