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

Leave a Reply

Your email address will not be published. Required fields are marked *