SO....: Win 7 64bits
DB....: Oracle 184.108.40.206 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 - 220.127.116.11) to ora11(18.104.22.168)?
2) Is there a way to restore only one tablespace, between instances and versions?
Potentailly you could re-install the Oracle software onto the PC and then as long as the database files are fine just start the database. Once available you would then have several options for migrating the data.
Since you have a backup then you ought to be able to use rman to restore the backup (to a new server) and access the database from there extracting just the tablespace of interest via export, database links, or transportable tablespaces.
Speaking of exports if you made one of your PC database then depending on its age, etc... you might just be able to use it to get the objects and data of interest.
You do not mention the platform the remaining database is on. This can be an important factor for what options are practical.