跳转到内容

RAC 攻击 - Oracle 集群数据库实战/数据库恢复

来自维基教科书,开放的书籍,开放的世界


此练习依赖于之前练习的完成。



  1. 清除 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;
  2. 预览整个数据库的恢复。为什么它会失败?如何修复这个问题?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
  3. 将 FRA 恢复到正确的共享位置,该位置是在实验 6 之前创建数据库时分配的。SQL> alter system set db_recovery_file_dest='+FRA'; System altered.
  4. 现在,使用共享存储重复数据库备份练习和本练习。


华夏公益教科书