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

    Restore asm alias datafile to new location extension dbf

    Ramstimo

      Hi All,


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

       

      Example:+DATA1/prod/datafile/data.318.799151641

       

      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.

       

       

      Thanks