Moving archives of ASM to disks

CREATE or replace DIRECTORY archive_ori AS '+FRAPROD/prod/archivelog/2010_06_15/';

CREATE or replace DIRECTORY archive_prod AS '/oracle/archiveprod/';

select 'exec DBMS_FILE_TRANSFER.COPY_FILE(''archive_ori'', '''||substr(name, instr(name,'/',-1)+1)||''', ''archive_prod'', ''1_'||sequence#||'_665321063.dbf'');'

FROM v$archived_log

WHERE sequence# BETWEEN 421835 AND 421886

and name like '+FRAPROD%'

ORDER BY sequence#;

by Márcio Santos