【Oracle】安装配置 数据库体系架构 PL/SQL 备份与恢复 性能调优 Oracle开发

您现在的位置：首页 > 网络学院 > 数据库 > Oracle > 备份与恢复 > 使用RMAN进行基于表空间的恢复

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

来源：作者：日期：2007-07-08

【聚杰网备份与恢复】使用RMAN进行基于表空间的恢复示范案例，仅供参考:
1.察看备份文件

$ rman target /Recovery Manager: Release 10.1.0.2.0 - 64bit ProductionCopyright (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

2.mount数据库

RMAN> startup mount;connected to target database (not started)Oracle instance starteddatabase mountedTotal System Global Area     314572800 bytesFixed Size                     1301704 bytesVariable Size                261890872 bytesDatabase Buffers              50331648 bytesRedo Buffers                   1048576 bytes

3.恢复数据文件

RMAN> restore datafile 1;Starting restore at 30-MAR-05allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=160 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to /opt/oracle/oradata/eygle/system01.dbfchannel ORA_DISK_1: restored backup piece 1piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_03_29/o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp tag=TAG20050329T065513channel ORA_DISK_1: restore completeFinished restore at 30-MAR-05