RMAN Example: Redirecting an Oracle Restore Using SET NEWNAME

When you redirect a restore for Oracle database 11gR2 or later by using the SET NEWNAME FOR DATABASE, or SET NEWNAME FOR TABLESPACE commands, you must specify variables in the file name to avoid name collisions.

Procedure

• To avoid name collisions, specify at least one of the substitution variables in the SET NEWNAME command: %b, %f, or %U.

  For information on the supported variables, see supported Oracle Redirected Restore File Name Variables variable.

  run 
  {
  set newname for database to "/u02/app/oracle/oradata/TST1/%U";
  restore database until time="TO_DATE('11/13/2013 01:53:36', 'MM/DD/YYYY HH24:MI:SS')";
  switch datafile all;
  }
  exit;
   run {
  recover database until scn 7266782191960;
  }
  exit;