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.807871839
RMAN> copy datafile 4 to ‘/u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf’;
Starting backup at 20-FEB-13 11:37:38
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+BIG_DATA/db1dup/datafile/hh_test.258.807871839
output file name=/u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf tag=TAG20130220T113743 RECID=3 STAMP=807881879
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 20-FEB-13 11:38:03
Starting Control File and SPFILE Autobackup at 20-FEB-13 11:38:03
piece handle=+FRA/db1dup/autobackup/2013_02_20/s_807881888.386.807881889 comment=NONE
Finished Control File and SPFILE Autobackup at 20-FEB-13 11:38:11
RMAN> RUN
{
SQL “ALTER TABLESPACE hh_test OFFLINE IMMEDIATE”;
SWITCH DATAFILE 4
TO DATAFILECOPY ‘/u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf’;
RECOVER TABLESPACE hh_test;
SQL “ALTER TABLESPACE hh_test ONLINE”;
}
sql statement: ALTER TABLESPACE hh_test OFFLINE IMMEDIATE
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=807881879 file name=/u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf
starting full resync of recovery catalog
full resync complete
Starting recover at 20-FEB-13 11:38:31
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 20-FEB-13 11:38:35
sql statement: ALTER TABLESPACE hh_test ONLINE
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 /u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf