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.
The example I have given has typo error.
Sorry for that...
Please check the below example:
set newname for datafile '+DATA1/prod/datafile/data.318.799151641' to '+TEST01/test/datafile/data01.dbf'
I want to know whether the above command will change datafile name or not.