Re: restore of database files and tempfiles

Posted by ErmanArslansOracleBlog on May 22, 2018; 7:47am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/restore-of-database-files-and-tempfiles-tp6057p6058.html

 If you want to explicitly name your datafiles, then you must use non-OMF format as shown below :

 SET newname FOR datafile 1 TO '+DATADG/T4IPLUS/datafile/system.dbf';
 SET newname FOR datafile 2 TO '+DATADG/T4IPLUS/datafile/sysaux.dbf';
 SET newname FOR datafile 3 TO '+DATADG/T4IPLUS/datafile/undotbs1.dbf';

and so on.

Since this involves your production, be careful. Risk is yours.

Ref: Set Newname to Full OMF Name is Ignored (Doc ID 2207480.1)