Solution:
I used below query to fix the path for the restored files, as path was wrong for some datafiles
select 'set newname for datafile '||file#||' to ''/u01/oradata/jblprov/'|| SUBSTR (NAME, INSTR (NAME, '/', -1) + 1)||''';' from v$datafile order by 1
I used below query to fix the path for the restored files, as path was wrong for some datafiles
select 'set newname for datafile '||file#||' to ''/u01/oradata/jblprov/'|| SUBSTR (NAME, INSTR (NAME, '/', -1) + 1)||''';' from v$datafile order by 1
No comments:
Post a Comment