SELECT columna1 FROM
(select '  ALTER DATABASE RENAME FILE '||''''||name||''''||' TO '||''''||
'/u02/oradata/sirio/'|| substr(name,
 instr(name, '/',-1,1) +1,
 length(name) )||''''||' ;'  columna1, 1  columna2  from v$datafile
UNION
select '  ALTER DATABASE RENAME FILE '||''''||member||''''||' TO '||''''||
'/u02/oradata/sirio/'|| substr(member,
 instr(member, '/',-1,1) +1,
 length(member) )||''''||' ;' , 2  from v$logfile)
ORDER BY columna2
/