RAC 攻擊 - Oracle 叢集資料庫實戰/資料庫恢復
此練習依賴於之前練習的完成。
- 清除 RMAN 通道和並行配置。RMAN> configure channel 1 device type disk clear; RMAN> configure channel 2 device type disk clear; RMAN> configure device type disk parallelism 1; RMAN> show all;
- 預覽整個資料庫的恢復。為什麼它會失敗？如何修復這個問題？RMAN> restore database preview; Starting restore at 04-MAY-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=114 instance=RAC1 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 05/04/2009 11:44:53 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore
- 將 FRA 恢復到正確的共享位置，該位置是在實驗 6 之前建立資料庫時分配的。SQL> alter system set db_recovery_file_dest='+FRA'; System altered.
- 現在，使用共享儲存重複資料庫備份練習和本練習。