Last modified on 5 April 2013, at 05:56

RAC Attack - Oracle Cluster Database at Home/Database Recovery


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.