RMAN系列-数据文件恢复

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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22741583/viewspace-683924/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22741583/viewspace-683924/