8 Replies Latest reply on Dec 3, 2012 8:54 AM by Fran

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


      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