TSPITR using backups from standby

Hi,

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. Received on Fri May 11 2007 - 15:47:09 CDT