TSPITR Works With an RMAN-Managed Auxiliary Instance - Oracle database instance used in the recovery process to perform the actual work of recovery.
The target time, the point in time or SCN that the tablespace will be left at after TSPITR
The recovery set, which consists of the datafiles containing the tablespaces to be recovered;
The auxiliary set, which includes datafiles required for TSPITR of the recovery set which are not themselves part of the recovery set - SYSTEM tablespace, UNDO segments.
The auxiliary instance has other files associated with it, such as a control file, parameter file, and online logs , but they are not part of the auxiliary set.
The auxiliary destination, an optional location on disk which can be used to store any of the auxiliary set datafiles, control files and online logs of the auxiliary instance.
To recover a truncated table, logical corruption, incorrect batch job etc. DB has to be in Arch Log mode.
Cannot recover dropped tablespaces, tables without their associated constraints, or constraints without the associated tables.
The target time, the point in time or SCN that the tablespace will be left at after TSPITR
The recovery set, which consists of the datafiles containing the tablespaces to be recovered;
The auxiliary set, which includes datafiles required for TSPITR of the recovery set which are not themselves part of the recovery set - SYSTEM tablespace, UNDO segments.
The auxiliary instance has other files associated with it, such as a control file, parameter file, and online logs , but they are not part of the auxiliary set.
The auxiliary destination, an optional location on disk which can be used to store any of the auxiliary set datafiles, control files and online logs of the auxiliary instance.
To recover a truncated table, logical corruption, incorrect batch job etc. DB has to be in Arch Log mode.
Cannot recover dropped tablespaces, tables without their associated constraints, or constraints without the associated tables.