This discussion is archived
3 Replies Latest reply: Jan 17, 2013 8:48 AM by Fabricio_Jorge RSS

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

Fabricio_Jorge Explorer
Currently Being Moderated
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.

Legend

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