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
Hi,

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

Legend

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