RMAN restore/recover DBF onto a different mount point

RMAN restore/recover DBF onto a different mount point

When a drive fails and takes a mount point down it's nessesary to recover
a lost datafile onto a different moint point.

Thankfully RMAN makes it very easy on us:

## in this example we lost datafile 6 which originally was:
##     /u03/oradata/SIDNAME/tools01.dbf
##
## our goal is to restore this file to:
##     /u04/oradata/SIDNAME/tools01.dbf
##


hostname.SIDNAME-> rman target /

RMAN> 
run {
      allocate channel c1 type disk;
      set newname for datafile 6 to '/u04/oradata/SIDNAME/tools01.dbf';
      restore datafile 6;
      switch datafile 6;
}

RMAN> recover datafile 6;

RMAN> exit

hostname.SIDNAME-> sqlplus /nolog

SQL> alter database datafile 6 online;

That's all.