RAC Attack - Oracle Cluster Database at Home/Database Recovery

This exercise depends on the completion of the previous exercises.

 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;

 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

 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.

 Now, repeat the exercise and this exercise with shared storage.

