RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM *** /oracle/oradata/orcl/system01.dbf
2 30 UNDOTBS1 *** /oracle/oradata/orcl/undotbs01.dbf
3 240 SYSAUX *** /oracle/oradata/orcl/sysaux01.dbf
4 5 USERS *** /oracle/oradata/orcl/users01.dbf
5 100 EXAMPLE *** /oracle/oradata/orcl/example01.dbf
6 0 JASON *** /oracle/oradata/orcl/jason01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /oracle/oradata/orcl/temp01.dbf
RMAN> sql 'alter database datafile 6 offline';
sql statement: alter database datafile 6 offline
RMAN> restore datafile 6;
Starting restore at 16-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /oracle/oradata/orcl/jason01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/orabak/databak/20110116_08m28bdb.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/orabak/databak/20110116_08m28bdb.dbf tag=TAG20110116T092810
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 16-JAN-11
RMAN> recover datafile 6;
Starting recover at 16-JAN-11
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:02
Finished recover at 16-JAN-11
RMAN> sql 'alter database datafile 6 online';
sql statement: alter database datafile 6 online
RMAN>