使用RMAN进行基于表空间的恢复

Nero 6高级使用图解
电脑使用常见问题解答
无需工具使用自带功能轻松优化XP
分区指南 实例解说fdisk工具的使用
Eclips使用秘技(绝对经典)
联讯证券同花顺软件分析系统使用
抠图—背景橡皮擦工具的使用
COPY命令使用说明
mental ray节点和灯光使用教程
DM分区软件使用详解
$ rman target /

Recovery Manager: Release 10.1.0.2.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: EYGLE (DBID=1337390772)

RMAN> list backup of datafile 1;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    131M       DISK        00:01:50     29-MAR-05
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20050329T065513
        Piece Name: /data5/flash_recovery_area/EYGLE/backupset/
2005_03_29/o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp
  List of Datafiles in backup set 17
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 10605717   29-MAR-05 /opt/oracle/oradata/eygle/system01.dbf

RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area     314572800 bytes
Fixed Size                     1301704 bytes
Variable Size                261890872 bytes
Database Buffers              50331648 bytes
Redo Buffers                   1048576 bytes

RMAN> restore datafile 1;
Starting restore at 30-MAR-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/eygle/system01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_03_29/
o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp tag=TAG20050329T065513
channel ORA_DISK_1: restore complete
Finished restore at 30-MAR-05