This discussion is archived
8 Replies Latest reply: Dec 3, 2012 12:54 AM by Fran RSS

Restore and recover tablespace(s) in another db using RMAN

aLuViAn Newbie
Currently Being Moderated

I'm using Oracle Standard edition 11gR2, actually that's why I'm posting this thread because I can't use TRANSPORT TABLESPACE feature.
I need to restore and recover two tablespaces, backed up in source database in another database. The destination db has been duplicated from the source db a couple of days ago so the structure is identical.
I cannot use Data Pump on this specific tablespace, because it causes some strange behavior in our application. So I took a backup from tablespaces and now I'm looking for a solution to restore and recover it in another db.
Is there any command to restore a tablespace from a specific file? I googled a lot and no luck so far..

Any ideas?

P.S: I use controlfile instead of recovery catalog.

Edited by: aLuViAn on Dec 2, 2012 11:55 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points