411 REFERENCE · Wikibooks
RAC Attack - Oracle Cluster Database at Home/Database Recovery
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
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 restoreRevert 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 Database Backups exercise and this exercise with shared storage.
Database Backups