Database Backup and Recovery (MOSC)

MOSC Banner

Can backups taken on a physical standby be used for TSPITR on the primary database?

edited Jun 23, 2021 7:15PM in Database Backup and Recovery (MOSC) 8 commentsAnswered

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>')";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center