Database Software

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!

RMAN Restore a particular table

User_PT6OPJul 13 2015 — edited Jul 13 2015

Dear All,

I have created a test db from prod as feb-2015 using rman duplicate command..

rman auxiliary /

duplicate database to test backup location '/xyz';

Now in case if i want to restore a particular table from prod backup as on mar-2015

I have a level0 backup available for mar-2015 of prod.

Is there a way i can just restore a particular table without have to restore entire database ?

If yes can i restore the table with a new name.

os ; rhel 6

db : 11.2.0.3

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2015

Added on Jul 13 2015

#performance-availability, #recovery-manager-rman

7 comments

2,122 views