RMAN> sql 'alter tablespace users offline';
 
sql statement: alter tablespace users offline
 
RMAN> restore tablespace users;
 
Starting restore at 17-JUL-04
using channel ORA_DISK_1
 
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /newvol/uu01/oracle/products/10.1/CRM10/users01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/admin/rman/o1_mf_nnnd0_WEEKLY_0hd040y7_.bkp tag=WEEKLY
channel ORA_DISK_1: restore complete
Finished restore at 17-JUL-04
 
RMAN> recover tablespace users;
 
Starting recover at 17-JUL-04
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /oracle/products/10.1/dw/users01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/admin/rman/o1_mf_nnnd1_MON_0hd0dbx2_.bkp tag=MON
channel ORA_DISK_1: restore complete
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /oracle/products/10.1/dw/users01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/admin/rman/o1_mf_nnnd1_TUE_0hd0h1mh_.bkp tag=TUE
channel ORA_DISK_1: restore complete

Similarly all backup sets from WED through SAT are applied ...

piece handle=/oracle/admin/rman/o1_mf_nnnd1_SAT_0hd0jlwv_.bkp tag=SAT
channel ORA_DISK_1: restore complete
 
starting media recovery
media recovery complete
 
Finished recover at 17-JUL-04

RMAN> sql 'alter tablespace users online';
 
sql statement: alter tablespace users online

RMAN>