RMAN set newname脚本:
windows:
set linesize 500
set pagesize 500
col file_name for a60
select 'set newname for datafile '||file_id||' to ''D:\Ora11gData\iypsprod2\'||substr(file_name, instr(file_name, '\', -1) + 1) || ''';' from dba_data_files;
linux:
set linesize 500
set pagesize 500
col file_name for a60
select 'set newname for datafile '||file_id||' to ''D:\Ora11gData\iypsprod2\'||substr(file_name, instr(file_name, '/', -1) + 1) || ''';' from dba_data_files;
暂无评论