RMAN to recover a tablespace

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1202915429)

RMAN>

RMAN> run {
2> sql "alter tablespace users offline immediate";
3> restore tablespace users;
4> recover tablespace users;
5> sql "alter tablespace users online";
6> }

sql statement: alter tablespace users offline immediate

Starting restore at 08-JAN-10

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
channel ORA_DISK_1: restoring datafile 00009
input datafilecopy recid=3 stamp=707754084 filename=C:\BACKUP\USERS01.DBF
destination for restore of datafile 00009: H:\ORACLE\ORADATA\IACM\USERS01.DBF
channel ORA_DISK_1: copied datafilecopy of datafile 00009
output filename=H:\ORACLE\ORADATA\IACM\USERS01.DBF recid=11 stamp=707786472
Finished restore at 08-JAN-10

Starting recover at 08-JAN-10
using channel ORA_DISK_1

starting media recovery
media recovery complete

Finished recover at 08-JAN-10

sql statement: alter tablespace users online

RMAN>