Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
Purpose of RMAN TSPITRRecovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.
RMAN TSPITR is most useful for the following situations:
To recover a logical database to a point different from the rest of
the physical database, when multiple logical databases exist in separate
tablespaces of one physical database. For example, you maintain logical
databases in the
personneltablespaces. An incorrect batch job or data manipulation language (DML) statement corrupts the data in only one tablespace.
To recover data lost after data definition language (DDL) operations
that change the structure of tables. You cannot use Flashback Table to
rewind a table to before the point of a structural change such as a
truncate table operation.
To recover a table after it has been dropped with the
To recover from the logical corruption of a table.
- To recover dropped tablespaces. In fact, RMAN can perform TSPITR on dropped tablespaces even when a recovery catalog is not used.
Source and More Info :- docs.oracle.com