以下的文章主要是對如何正確的使用Oracle RMAN來進行基於相關表空間的恢復做一詳細介紹,我們通過示范案例來對Oracle RMAN來進行基於相關表空間的恢復進行說明,以下就是相關內容的描述,僅供參考:
1.察看備份文件
復制代碼$ 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數據庫
復制代碼
- Oracle 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.恢復數據文件
復制代碼Oracle 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
上述的相關內容就是對使用Oracle RMAN進行基於表空間的恢復的描述,希望會給你帶來一些幫助在此方面。