RMAN> run {
2> SQL 'ALTER TABLESPACE users OFFLINE';
3> RESTORE TABLESPACE users;
4> RECOVER TABLESPACE users;
5> SQL 'ALTER TABLESPACE users ONLINE';
6> }

SQL statement: ALTER TABLESPACE users OFFLINE
starting full resync OF recovery catalog
full resync complete

Starting restore AT 13/09/12
USING channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup SET restore
channel ORA_DISK_1: specifying datafile(s) TO restore FROM backup SET
channel ORA_DISK_1: restoring datafile 00004 TO D:\ORADATA\ORACLE\USERS01.DBF
channel ORA_DISK_1: reading FROM backup piece B:\BACKUP\BACKUP_20120911-234-7ANK
UL4O_1_1
channel ORA_DISK_1: piece handle=B:\BACKUP\BACKUP_20120911-234-7ANKUL4O_1_1 tag=
TAG20120911T160231
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: reading FROM backup piece B:\BACKUP\BACKUP_20120911-234-7ANK
UL4O_2_1
channel ORA_DISK_1: piece handle=B:\BACKUP\BACKUP_20120911-234-7ANKUL4O_2_1 tag=
TAG20120911T160231
channel ORA_DISK_1: restored backup piece 2
channel ORA_DISK_1: restore complete, elapsed TIME: 00:01:40
Finished restore AT 13/09/12

Starting recover AT 13/09/12
USING channel ORA_DISK_1

starting media recovery

archived LOG FOR thread 1 WITH SEQUENCE 1102 IS already ON disk AS FILE B:\BACKU
P\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1102_853BFX9C_.ARC
channel ORA_DISK_1: starting archived LOG restore TO DEFAULT destination
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1086
channel ORA_DISK_1: reading FROM backup piece B:\BACKUP\BACKUPLOG_7CNKUMIP_1_1_7
93729625
channel ORA_DISK_1: piece handle=B:\BACKUP\BACKUPLOG_7CNKUMIP_1_1_793729625 tag=
TAG20120911T162704
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed TIME: 00:00:03
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1086_853S9
VL2_.ARC thread=1 SEQUENCE=1086
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1086_853S9
VL2_.ARC RECID=1127 STAMP=793900380
channel ORA_DISK_1: starting archived LOG restore TO DEFAULT destination
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1087
channel ORA_DISK_1: reading FROM backup piece B:\BACKUP\BACKUPLOG_7DNKUN0J_1_1_7
93730067
channel ORA_DISK_1: piece handle=B:\BACKUP\BACKUPLOG_7DNKUN0J_1_1_793730067 tag=
TAG20120911T163427
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed TIME: 00:00:01
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1087_853S9
YY9_.ARC thread=1 SEQUENCE=1087
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1087_853S9
YY9_.ARC RECID=1128 STAMP=793900383
channel ORA_DISK_1: starting archived LOG restore TO DEFAULT destination
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1088
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1089
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1090
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1091
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1092
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1093
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1094
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1095
channel ORA_DISK_1: reading FROM backup piece B:\BACKUP\BACKUPLOG_7FNKVV6D_1_1_7
93771213
channel ORA_DISK_1: piece handle=B:\BACKUP\BACKUPLOG_7FNKVV6D_1_1_793771213 tag=
TAG20120912T040012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed TIME: 00:00:25
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1088_853SB
0WC_.ARC thread=1 SEQUENCE=1088
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1088_853SB
0WC_.ARC RECID=1131 STAMP=793900399
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1089_853SB
0SF_.ARC thread=1 SEQUENCE=1089
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1089_853SB
0SF_.ARC RECID=1132 STAMP=793900400
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1090_853SB
0PH_.ARC thread=1 SEQUENCE=1090
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1090_853SB
0PH_.ARC RECID=1135 STAMP=793900402
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1091_853SB
0M2_.ARC thread=1 SEQUENCE=1091
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1091_853SB
0M2_.ARC RECID=1136 STAMP=793900402
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1092_853SB
0TD_.ARC thread=1 SEQUENCE=1092
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1092_853SB
0TD_.ARC RECID=1130 STAMP=793900399
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1093_853SB
0NK_.ARC thread=1 SEQUENCE=1093
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1093_853SB
0NK_.ARC RECID=1134 STAMP=793900402
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1094_853SB
0QY_.ARC thread=1 SEQUENCE=1094
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1094_853SB
0QY_.ARC RECID=1133 STAMP=793900401
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1095_853SB
0Y9_.ARC thread=1 SEQUENCE=1095
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1095_853SB
0Y9_.ARC RECID=1129 STAMP=793900390
channel ORA_DISK_1: starting archived LOG restore TO DEFAULT destination
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1096
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1097
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1098
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1099
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1100
channel ORA_DISK_1: restoring archived LOG
archived LOG thread=1 SEQUENCE=1101
channel ORA_DISK_1: reading FROM backup piece B:\BACKUP\BACKUPLOG_7HNL2JIF_1_1_7
93857615
channel ORA_DISK_1: piece handle=B:\BACKUP\BACKUPLOG_7HNL2JIF_1_1_793857615 tag=
TAG20120913T040015
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed TIME: 00:00:15
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1096_853SC
4QZ_.ARC thread=1 SEQUENCE=1096
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1096_853SC
4QZ_.ARC RECID=1138 STAMP=793900432
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1097_853SC
4SG_.ARC thread=1 SEQUENCE=1097
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1097_853SC
4SG_.ARC RECID=1139 STAMP=793900432
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1098_853SC
4P0_.ARC thread=1 SEQUENCE=1098
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1098_853SC
4P0_.ARC RECID=1141 STAMP=793900433
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1099_853SC
4TX_.ARC thread=1 SEQUENCE=1099
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1099_853SC
4TX_.ARC RECID=1140 STAMP=793900432
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1100_853SC
4M3_.ARC thread=1 SEQUENCE=1100
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1100_853SC
4M3_.ARC RECID=1142 STAMP=793900433
channel DEFAULT: deleting archived LOG(s)
archived LOG FILE name=B:\BACKUP\ORACLE\ARCHIVELOG\2012_09_13\O1_MF_1_1101_853SC
4XT_.ARC RECID=1137 STAMP=793900432
media recovery complete, elapsed TIME: 00:00:07
Finished recover AT 13/09/12
starting full resync OF recovery catalog
full resync complete

SQL statement: ALTER TABLESPACE users ONLINE
starting full resync OF recovery catalog
full resync complete