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

文章作者 100test 发表时间 2007:07:12 12:50:27
来源 100Test.Com百考试题网

示范案例，仅供参考:

1.察看备份文件

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

$ 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

2.mount数据库

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

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

3.恢复数据文件

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

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

src="/oracle/js/wxgg_oracle.js">