导航

RMAN系列-数据文件恢复

Posted on 2011-03-15 22:23  datalife  阅读(167)  评论(0编辑  收藏  举报

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>