I would like to ask for your opinion/advice regarding the following
scenario. We have a primary 10.2.0.3 RAC database which has a physical
standby database, both sites being manged through dataguard. Every
night full RMAN backups are taken for the primary and standby
databases. Between the primary and standby sites we do not have any
shared storage like NFS or SAMBA (because of the problems mentioned
into Note:413098.1).
Now, as far as I know, backups of datafiles/archives taken from the
standby can be used on primary, am I right? So, what I would like to
achieve is to perform a TSPITR of one particular tablespace by taking
a backup control file from the primary but using datafile copies and
archives from the standby. And of course, because I don't want to load
too much the primary, the auxiliary instance should be located on the
standby machine. Is this possible? Has anybody tried this before?

Many thanks!

talek.