Can backups taken on a physical standby be used for TSPITR on the primary database?
For a Data Guard setup where backups are taken on the physical standby database, can we use the standby backup to run tablespace recovery (TSPITR) on the primary database? The controlfile is also being backed up from the standby as an autobackup while running database and log backups.
recover tablespace <tablespace_name> until time = "to_date('<date>','DD-MON-YYYY:HH24:MI:SS')" auxiliary destination '<location>';
Getting this error when I run the above RMAN command:
ORA-01666: control file is for a standby database
Also tried to restore the control file first with restore primary controlfile to '<path> until time "to_date('<date>', '<format>')";