RAC Attack - Oracle Cluster Database at Home/Database Recovery

From Wikibooks, open books for an open world
Jump to navigation Jump to search


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.