8 Replies Latest reply: Jul 4, 2013 11:12 PM by Ramstimo RSS

    Restore asm alias datafile to new location extension dbf


      Hi All,

      I have to restore prod database to test database,But in prod one datafile is created with the asm alias.




      Is the below statement will works when I restore in test.


      set newname for datafile 5 to '+DATA1/prod/datafile/data01.dbf'

      restore datafile 5;


      Is there any other work around to restore the asm alias to new location with dbf extension.