You can
also use Enterprise Manager to perform TSPITR. Navigate to Availability >
Perform Recovery. In the User Directed Recovery section, select Tablespaces
from the Recovery Scope drop-down menu.
There are
three operations you can perform, for tablespaces:
•
Recover
to current time or a previous point in time: Restores the data files for the tablespace, if needed.
This operation then uses redo to recover to the time you specify: either the
current time or a time in the past. This is the combination of the following
two operations.
•
Restore
tablespaces: Only
restore the data files for the tablespace. No recovery is performed.
•
Recover
from previously restored tablespaces:
Perform recovery (redo application) only, of the tablespace’s data files.
RMAN TSPITR
Processing
RMAN
performs the following steps:
1.
Creates
the auxiliary instance, starts it, and connects to it
2.
Takes
the tablespaces that will be recovered offline
3.
Restores
a backup control file from a point in time before the target time to the auxiliary
instance
4.
Restores
the data files from the recovery set and the auxiliary set to the auxiliary
instance
5.
Recovers
the restored data files to the specified time
6.
Opens
the auxiliary database with the RESETLOGS option
