RMAN> report schema;
Report of database schema for database with db_unique_name DB1DUP
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 325 SYSTEM YES +BIG_DATA/db1dup/datafile/system.260.807722583
2 325 SYSAUX NO +BIG_DATA/db1dup/datafile/sysaux.261.807722585
3 200 UNDOTBS1 YES +BIG_DATA/db1dup/datafile/undotbs1.259.807722585
4 125 HH_TEST NO +BIG_DATA/db1dup/datafile/hh_test.258.807733867
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 20 TEMPTS1 20 +BIG_DATA/db1dup/tempfile/tempts1.270.807187371
RMAN> sql ‘alter database datafile 4 offline’;
sql statement: alter database datafile 4 offline
RMAN> restore datafile 4;
Starting restore at 18-FEB-13 18:37:25
using channel ORA_DISK_1
using channel ORA_DISK_2
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 +BIG_DATA/db1dup/datafile/hh_test.258.807733867
channel ORA_DISK_1: reading from backup piece +FRA/db1dup/backupset/2013_02_18/nnndf0_tag20130218t183250_0.337.807733977
channel ORA_DISK_1: piece handle=+FRA/db1dup/backupset/2013_02_18/nnndf0_tag20130218t183250_0.337.807733977 tag=TAG20130218T183250
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 18-FEB-13 18:37:32
starting full resync of recovery catalog
full resync complete
RMAN> recover datafile 4;
Starting recover at 18-FEB-13 18:37:52
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
media recovery complete, elapsed time: 00:00:02
Finished recover at 18-FEB-13 18:37:55
RMAN> sql ‘alter database datafile 4 online’;
sql statement: alter database datafile 4 online
RMAN> sql ‘ alter tablespace hh_test online’;
sql statement: alter tablespace hh_test online