Reconstructing
the contents of an entire database or a part of it from a backup typically
involves two phases: retrieving a copy of the data file from a backup, and
reapplying changes to the file since the backup from the archived and online
redo logs, to bring the database to the desired SCN (usually the most recent
one).
The RESTORE
command retrieves the data file onto disk from a backup location on tape, disk,
or other media, and makes it available to the database server. RMAN restores
from backup any archived redo logs required during the recovery operation. If
backups are stored on a media manager, channels must be configured or allocated
for use in accessing backups stored there.
The RECOVER
command takes the restored copy of the data file and applies to it the changes
recorded in the database’s redo logs.
RMAN> SQL 'ALTER TABLESPACE inv_tbs OFFLINE
IMMEDIATE';
RMAN> RESTORE TABLESPACE inv_tbs;
RMAN> RECOVER TABLESPACE inv_tbs;
RMAN> SQL 'ALTER TABLESPACE inv_tbs ONLINE';
