I need to restore several tablespaces from an RMAN database backup (DB-1) to a different database (DB-2) on a different server than where they originated. These tablespaces currently do not exist in DB-2. Other tablespaces do exist, so datafiles will not have the same file number in the target database. Both source and target databases are 9iRAC. Can this be done? If so, how? Export/import isn't feasible due to file sizes and nature of data.
From what I understand, in order to use transportable tablespaces as a means to copy the tablespaces, I would need to set up a temporary database, do a full restore from the rman backup, alter the tablespaces to be copied to be transportable, and then export/import the tablespaces. Is this correct?
The source database is a 24x7 production database so I can't take the ts offline. I would have to build an intermediate db in order to do that, in which case it would probably be easier to just create a temporary database and do a full restore.
Thanks for all the input. You definitely saved me some time & trouble.