3 Replies Latest reply: Jan 17, 2013 10:48 AM by Fabricio_Jorge RSS

    Possible strategies for restoring a single tablespace from instance A to B

    Fabricio_Jorge
      Hi all,

      SO....: Win 7 64bits
      DB....: Oracle 11.2.0.3 EE 64 bits

      In my notebook, i have 2 instances (orateste and ora11). They are all for testing purpose. I don't know what happened but, a problem in a partition of my SO made the Oracle software unavailable. I cannot start instance orateste. Even the windows service related to the instance have disappeared from services.msc. What i want to do is to restore only one tablespace from instance orateste to ora11. I have a full rman database backup from D-1. What are the possible solutions?

      1) Restore the entire database (orateste - 11.2.0.1) to ora11(11.2.0.3)?

      2) Is there a way to restore only one tablespace, between instances and versions?

      Thanks in advance.