This content has been marked as final. Show 8 replies
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.