恢复冷备

select distinct substr(name, 1,instr(name,'/',-1)-1) from v$datafile;
select distinct substr(member, 1,instr(member,'/',-1)-1) from v$logfile;
select distinct substr(name, 1,instr(name,'/',-1)-1) from v$tempfile;

select 'alter database rename file '''||name||''' to ''/newpath/'||substr(name,instr(name,'/',-1)+1)||''';' from v$datafile where name like '/oldpath%';
select 'alter database rename file '''||member||''' to ''/newpath/'||substr(member,instr(member,'/',-1)+1)||''';' from v$logfile;
select 'alter database rename file '''||name||''' to ''/newpath/'||substr(name,instr(name,'/',-1)+1)||''';' from v$tempfile;