This content has been marked as final. Show 4 replies
Hello;1 person found this helpful
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
I thank You !
Only one Oracle MOS note on this :
OERR: RMAN 6085 must use SET NEWNAME command to restore datafile %s [ID 48232.1]
But it has no new information.
Yes , Sir
thank You again