Jump to content

RAC Attack - Oracle Cluster Database at Home/Database Recovery

From Wikibooks, open books for an open world


This exercise depends on the completion of the previous exercises.



  1. Clear the RMAN channels and parallelism configuration. 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. Preview a restore of the entire database. Why does it fail? How can you remediate this? 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. Revert the FRA to the correct shared location, assigned during DB creation before lab 6. SQL> alter system set db_recovery_file_dest='+FRA'; System altered.
  4. Now, repeat the Database Backups exercise and this exercise with shared storage.