8 Replies Latest reply on Jul 5, 2013 4:12 AM by Ramstimo

    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.