This content has been marked as final. Show 4 replies
RMAN-06085 - A RESTORE command for the specified datafile could not find a destination name for the specified datafile.
With a little dynamic SQL this is easy :
SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/RECLONE/system01.dbf'; So it will create the datafile in the correct path.
Make sure your file structure is setup too.
set heading off set feedback off set pagesize 400 select ' newname for datafile ' || file#|| ' to ' || name from v$datafile;
Edited by: mseberg on Nov 8, 2012 7:17 AM